Hello,
I need to transform the sample data in the Input Sheet of the attached excel file to the output sheet.
My input data is structured like this.
My output data needs to be like this
I can do this with a filter and select, Union and Summarize but I was wondering if there is an easier way.
Thanks,
Michael
Solved! Go to Solution.
Hi @mstoler ,
You can get that result by playing with transpose + cross-tab tools.
Here is an example for you.
Best,
Fernando Vizcaino
Excellent.
The image you provided made it clear and I implemented it.
Michael