Transposing header set as date to column

[pauloplata]

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

[#2]

@pauloplata 

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.