Here is my problem today, I've tried several ways, but did not get the expected result:
I have several columns which include several rows of data
Each row has multiple lines of data in it
I would like to be able to separate each line of data from each row
Each line of data should be, eventually, a row.
I include an excel file to be more explicit about my request. The first tab show how the data that I have is extracted and the tab "Expected results"... well... shows the objective I would like to achieve! 😁
Please take a look at the attached workflow. The best way I find to do this is by Transposing all the columns into one row, then using the Text-to-Columns tool to split into rows. From there you can Cross-Tab the data back into its original layout.