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 |