Forum Discussion
ChristoNindyoVNS70
Nov 28, 2023Copper Contributor
Data transpose automatically in excel
Hello experts,
I still learn how to do transpose in excel. Until now, I still do some of it manually
I want change this table
into this table
Thanks !
- Patrick2788Silver Contributor
Data from picture didn't take kindly to the provided image so I've created a scaled down sample. I've also opted to show full dates from the column headers.
One approach is to un-pivot the data in PowerQuery.
- LorenzoSilver Contributor
Setup is not ideal but there might be something to do (not sure yet)
- What version of Excel do you run?
- On which OS (Windows, Mac...)?
- Could you attached (if not allowed yet, upload to OneDrive, Google Drive... and share) a sample representative workbook so we don't spend time creating dummy data that might not reflect reality?