Taking Columns that are horizaontial into a vretical column

J

Jerry Arnone, PMP

I have a group of column headings that are horizontial from columns A to II.
I would like to take these column headings and have them all in Column A
vertically.

Is there a simple way to do this?
 
B

Bob Umlas, Excel MVP

Sure. Select them all, Use Edit/Copy, Click in column A somewhere, (A1,
perhaps), use edit/Paste Special, select the "Transpose" checkbox.
Bob Umlas
Excel MVP
 
Top