Aug 03 2021 08:30 PM
Hi, I have this data from pivot.
Can anyone guide how can I change it to something like the following example (without manual work)?
I have attached an example pivot file in case anyone wants to try playing around.
Thank you very much.
Regards,
Nichanal
Aug 03 2021 10:55 PM
@nichanall Consider using PowerQuery to unpivot the data. If you have used PQ before, you'll know how to do that. If you haven't, learn some basics first from the attached link. In there, chapter 13 clearly explains the process of unpivoting data.
https://exceloffthegrid.com/power-query-introduction/