Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to rotate table clockwise
I have a table with field labels in column A (A2 to A16). I'd like to rotate
this table clockwise, i.e. have the field labels on the top of the table in A2 through I2. I tried to build a PivotTable to no avail... Does not matter what I click on or highlight in the original table - the whole table, the column A or just the A2 cell. For some reason, only the text in the A2 or the items in A2 through I2 appear in the list. But I need the A2 down to A16 be on the list to put them on top of the columns... How can I do it? May someone please give me step-by-step instructions? Thanks for your assistance. -- Ilya Zeldes Fort Myers, Florida |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to rotate table clockwise
To be precise I expect you don't actuall want *clockwise rotation*
but a simple transposition, ie rotate about the diagonal assuming a2-16 are labels and b2:?16 is the data (? being the last column) select the whole table Copy, Paste Special - transpose Steve On Thu, 10 Aug 2006 17:11:10 +0100, ilyaz wrote: I have a table with field labels in column A (A2 to A16). I'd like to rotate this table clockwise, i.e. have the field labels on the top of the table in A2 through I2. I tried to build a PivotTable to no avail... Does not matter what I click on or highlight in the original table - the whole table, the column A or just the A2 cell. For some reason, only the text in the A2 or the items in A2 through I2 appear in the list. But I need the A2 down to A16 be on the list to put them on top of the columns... How can I do it? May someone please give me step-by-step instructions? Thanks for your assistance. -- Steve (3) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to rotate table clockwise
Copy A2:A16
EditPaste SpecialTransposeOKEsc. You will need a n empty row to paste them into. Delete the original A2:A16 when happy. Gord Dibben MS Excel MVP On Thu, 10 Aug 2006 12:11:10 -0400, "ilyaz" wrote: I have a table with field labels in column A (A2 to A16). I'd like to rotate this table clockwise, i.e. have the field labels on the top of the table in A2 through I2. I tried to build a PivotTable to no avail... Does not matter what I click on or highlight in the original table - the whole table, the column A or just the A2 cell. For some reason, only the text in the A2 or the items in A2 through I2 appear in the list. But I need the A2 down to A16 be on the list to put them on top of the columns... How can I do it? May someone please give me step-by-step instructions? Thanks for your assistance. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to rotate table clockwise
Geeeeeeessss! That was easy! Thanks to both of you, Steve and Gord!
Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Copy A2:A16 EditPaste SpecialTransposeOKEsc. You will need a n empty row to paste them into. Delete the original A2:A16 when happy. Gord Dibben MS Excel MVP On Thu, 10 Aug 2006 12:11:10 -0400, "ilyaz" wrote: I have a table with field labels in column A (A2 to A16). I'd like to rotate this table clockwise, i.e. have the field labels on the top of the table in A2 through I2. I tried to build a PivotTable to no avail... Does not matter what I click on or highlight in the original table - the whole table, the column A or just the A2 cell. For some reason, only the text in the A2 or the items in A2 through I2 appear in the list. But I need the A2 down to A16 be on the list to put them on top of the columns... How can I do it? May someone please give me step-by-step instructions? Thanks for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Rotate a Excel table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |