Aug 27 2021 03:26 AM
Hi,
I have a large data set which has headers as dates and I need to transpose to columns for better analysis.
Could you please help me understand how to do this?
Many thanks
Aug 27 2021 03:33 AM
Click in cell A1.
Press Ctrl+A to select the entire range.
Press Ctrl+C to copy the range.
Create a new sheet.
Click the lower half of the Paste button on the Home tab of the ribbon.
Press T or select Transpose from the drop-down menu.