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

ChristoNindyoVNS70_0-1701176988802.png

 

into this table 

ChristoNindyoVNS70_1-1701177136189.png

 

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?

@ChristoNindyoVNS70 

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.

Patrick2788_0-1701287022006.png