Multiple columns to rows

[Andyhjtran]

Hi All,

I have the following data set:

And I'm trying to do text to rows for columns 2, 3, 4 and 5 (delimiter is *) so it looks like this:

I have attached my example workflow, but if anyone could help me, that'll be greatly appreciated.

[christine_assaad · Accepted solution]

Hi @Andyhjtran 

I used Text to column to parse the data into rows based on * then I used multiple Join based on position. Please check the attached and let us know. Cheers!

[Andyhjtran]

Hi @christine_assaad, thank you for helping out in such a timely manner. Unfortunately, we're not allowed to use the "join multiple" tool as it does not allow us to see if there's any rows that drop out of workflow. I've tried using 3 different "join" tools instead, but it just splits the record out into way too many rows:

Do you have any other tips or guidance to resolve this?

[apathetichell · Accepted solution]