Transposing header set as date to column

%3CLINGO-SUB%20id%3D%22lingo-sub-2691836%22%20slang%3D%22en-US%22%3ETransposing%20header%20set%20as%20date%20to%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2691836%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20data%20set%20which%20has%20headers%20as%20dates%20and%20I%20need%20to%20transpose%20to%20columns%20for%20better%20analysis.%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20help%20me%20understand%20how%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2691836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2691874%22%20slang%3D%22en-US%22%3ERe%3A%20Transposing%20header%20set%20as%20date%20to%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2691874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139312%22%20target%3D%22_blank%22%3E%40pauloplata%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20in%20cell%20A1.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BA%20to%20select%20the%20entire%20range.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BC%20to%20copy%20the%20range.%3C%2FP%3E%0A%3CP%3ECreate%20a%20new%20sheet.%3C%2FP%3E%0A%3CP%3EClick%20the%20lower%20half%20of%20the%20Paste%20button%20on%20the%20Home%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EPress%20T%20or%20select%20Transpose%20from%20the%20drop-down%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@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.