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.
Solved! Go to 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 : )
Thank you.
Happy to help : ) @jmedidi
If the response helps please don't forget to mark it as solution.
Cheers and have a nice day!