| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flip flopping columns and rows
I have a spreadsheet that has 1 row with 20 columns. I would like to make it
1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to do this, maybe a macro or formula or something? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip flopping columns and rows
copy the 20 columns. right click in (presumably) cell a2 Paste Special
Transpose "GKW in GA" wrote: I have a spreadsheet that has 1 row with 20 columns. I would like to make it 1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to do this, maybe a macro or formula or something? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip flopping columns and rows
that does exactly what I want.............thanks
"Beans" wrote: copy the 20 columns. right click in (presumably) cell a2 Paste Special Transpose "GKW in GA" wrote: I have a spreadsheet that has 1 row with 20 columns. I would like to make it 1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to do this, maybe a macro or formula or something? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flip flopping columns and rows
CopyPaste SpecialTranspose may be easiest.
Formula.............=INDEX($1:$1,ROWS($1:1)) entered in A2 and dragged down. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 08:49:04 -0700, GKW in GA wrote: I have a spreadsheet that has 1 row with 20 columns. I would like to make it 1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to do this, maybe a macro or formula or something? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Flip columns of data | Excel Discussion (Misc queries) | |||
| Images inside . . I need to Flip Columns, to Rows & Visa Versa?? SIMPLE RIGHT? :( | Excel Discussion (Misc queries) | |||
| How to flip the rows to column | Excel Discussion (Misc queries) | |||
| How dio you flip a worksheet that the columns start on the right | Excel Discussion (Misc queries) | |||
| How dio you flip a worksheet that the columns start on the right | Excel Discussion (Misc queries) | |||
Linear Mode
