Forum Discussion
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 !
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.