Forum Discussion
Solved
Transform data from rows to columns when the column headers repeat?
I have data that comes out as shown below (Raw Data), however, all of the ratings are listed in rows based on the individual/customer record they are on. I want each rating to be under the first set ...
Take a look at the attached file. Basically just split the table and then append back into itself
File:
Take a look at the attached file. Basically just split the table and then append back into itself
File:
Thanks Anonymous, that works beautifully!
