| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving a row to a column
I have a list in column a - the only thing on the sheet.
I want to move it so that it becomes a row. ie I want A1 to stay put. I want A2 to move to B1, A3 to C1, etc. Is there a simple code that will do that? TIA Papa |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
moving a row to a column
Paste Special/ Transpose
-- David Biddulph "Papa Jonah" wrote in message ... I have a list in column a - the only thing on the sheet. I want to move it so that it becomes a row. ie I want A1 to stay put. I want A2 to move to B1, A3 to C1, etc. Is there a simple code that will do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
moving a row to a column
Try this in B1 and copy across:
=INDEX($A1:$A10,COLUMN()) Biff "Papa Jonah" wrote in message ... I have a list in column a - the only thing on the sheet. I want to move it so that it becomes a row. ie I want A1 to stay put. I want A2 to move to B1, A3 to C1, etc. Is there a simple code that will do that? TIA Papa |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
moving a row to a column
I apparently don't know how to do that because I keep getting an error about
the paste area being a different size. "David Biddulph" wrote: Paste Special/ Transpose -- David Biddulph "Papa Jonah" wrote in message ... I have a list in column a - the only thing on the sheet. I want to move it so that it becomes a row. ie I want A1 to stay put. I want A2 to move to B1, A3 to C1, etc. Is there a simple code that will do that? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
moving a row to a column
Suppose your range is A1:A10.
Select A2:A10 Copy that range Select cell B1 Paste SpecialTransposeOK Biff "Papa Jonah" wrote in message ... I apparently don't know how to do that because I keep getting an error about the paste area being a different size. "David Biddulph" wrote: Paste Special/ Transpose -- David Biddulph "Papa Jonah" wrote in message ... I have a list in column a - the only thing on the sheet. I want to move it so that it becomes a row. ie I want A1 to stay put. I want A2 to move to B1, A3 to C1, etc. Is there a simple code that will do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
