Split data based on number of rows

Question

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.

Split_Data.xlsx

atcodedog05 · Accepted Answer

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 Answer

@jmedidi,

Another one with multi-row formula :

Attached the workflow,

Hope this helps!