Is there away to take the values in a Join/Collect cell and separating it in to different columns.

Jacob Mizer

I have a join/distinct/collect Char(10), and some of the Cells pull data 1, and 2. Is the formula to separate that data into separate columns? So 1 would go to the 1st column, and 2 would go into the second column.

Jacob Mizer

@Andrée Starå I think I got it figured out by adding a + count I found in another answer.

Andrée Starå

Hi @Jacob Mizer

I hope you're well and safe!

Yes, it's possible.

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jacob Mizer

@Andrée Starå I think I got it figured out by adding a + count I found in another answer.

Andrée Starå

@Jacob Mizer

Excellent!

Glad you got it working!

john.misiewicz@gmail.com

Jacob Mizer Could you share this remedy please?

Genevieve P.

Hi @john.misiewicz@gmail.com

Here's another thread that shows how you could use INDEX referencing a column with numbers to split out values down rows.

Cheers,

Genevieve

john.misiewicz@gmail.com

Thanks @Genevieve P. I OP question that has not been answered also. Since you were so fast to respond to this, I wonder if you can look at my other question posted on 3/1.

Genevieve P.

Hi @john.misiewicz@gmail.com

Checking in today it looks like you've received an answer, if this is the question you're talking about!

Cheers,

Genevieve

merrycheyers

@Jacob Mizer could you share your formula?