| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Taking data from 3 columns to make the fourth. | Excel Worksheet Functions | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| repeat formulae taking into account previous column's info? | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
