Parsing to Rows for Multiple Columns using Text-To-Column Tool

[hisyam10]

Hello and Good Day All. How do I parse to rows using Text-to-Column tool but for multiple fields?
The structure is almost the same but currently, I have around 141 columns to parse to rows. I do not want to put 141 Text-to-Column tools just to parse each of the columns.

Attached is the workflow and data. I appreciate your help with this.

Thank you very much.

[paulfound · Accepted solution]

Hi @hisyam10 

I have added a row id per page so that when you ross tab you can group by.

[atcodedog05 · Accepted solution]

Hi @hisyam10 ,

I think i get what you are trying to achieve.

There is a workflow. It generates Group ID (unique to Page and not overall)

 Output.

Hope this helps.

Please mark my post as solution if it helps.

[hisyam10]

Thank you very much @paulfound ! You just saved my life. I appreciate it very much.

[hisyam10]

Hi @atcodedog05 I tried your workflow and it works fantastic. Thank you very much ! I really appreciate it.

[atcodedog05]

Hi @hisyam10 

Happy to help : )