Taking Columns that are horizaontial into a vretical column
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? -- Jerry |
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 "Jerry Arnone, PMP" wrote: 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? -- Jerry |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com