Split data based on number of rows

[jmedidi]

I am trying to split text to columns from text based on specific number of rows.

I attached the file for reference. Appreciate the support.

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Here is how you can do it.

Workflow:

1. Since i know each time a record id occurs its a new column. I am using tile tool unique value row_id to generate seq numbers for each row_id occurence.

2. Using crosstab row_id as key, seqvalue as name and text as value convert it to table.

Hope this helps : )

[messi007 · Accepted solution]

@jmedidi,

Another one with multi-row formula :

Attached the workflow,

Hope this helps!

[jmedidi]

Thank you.

[atcodedog05]

Happy to help : ) @jmedidi 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!