Forum Discussion
Transposing header set as date to column
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
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.