Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Data transpose automatically in excel

Copper Contributor

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 !

2 Replies

Hi @ChristoNindyoVNS70 


Setup is not ideal but there might be something to do (not sure yet)

  1. What version of Excel do you run?
  2. On which OS (Windows, Mac...)?
  3. 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?


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.