Forum Discussion
Re-tabulate Data in different layout
afzalbaharudin I would use PowerQuery (PQ) for this, assuming that you are working with a substantial amount of data, over and over again. Example attached. If you are not familiar with PQ, the site in the link below would be a good place to start learning about it.
https://exceloffthegrid.com/power-query-introduction/
Chapter 13 deals with "Unpivot data", which is what you want to do.
If, on the other hand, your data set isn't all that large, you could consider to just do a few manual copy/paste steps and forget about complex formulae. That would probably take 30 seconds.
afzalbaharudin I would use PowerQuery (PQ) for this, assuming that you are working with a substantial amount of data, over and over again. Example attached. If you are not familiar with PQ, the site in the link below would be a good place to start learning about it.
https://exceloffthegrid.com/power-query-introduction/
Chapter 13 deals with "Unpivot data", which is what you want to do.
If, on the other hand, your data set isn't all that large, you could consider to just do a few manual copy/paste steps and forget about complex formulae. That would probably take 30 seconds.