Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
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.