Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flipping Cell Data Horizontal/Vertical
Hello,
I hope I can describe this correctly to see if there is an Excel macro already available: Is there a function or macro that can take a set of cells and "flip" it so that it runs perpendicularly to its original orientation? For example, if one has values in column A1 through A5, this macro would allow you to select that data, run the macro, and the resulting data would then appear in cells A1 through E1. (The reverse would also be possible.) This would help avoid having to retype, say, query column headers imported into Excel if one wanted those header names to run vertically instead of horizontally. Thanks in advance for any help. Regards, Shepherdmoon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flipping Cell Data Horizontal/Vertical
Copy the data and then use Edit|Paste Special. Select the Transpose option and click OK.
-- John Green - Excel MVP Sydney Australia "Shepherd Moon" wrote in message om... Hello, I hope I can describe this correctly to see if there is an Excel macro already available: Is there a function or macro that can take a set of cells and "flip" it so that it runs perpendicularly to its original orientation? For example, if one has values in column A1 through A5, this macro would allow you to select that data, run the macro, and the resulting data would then appear in cells A1 through E1. (The reverse would also be possible.) This would help avoid having to retype, say, query column headers imported into Excel if one wanted those header names to run vertically instead of horizontally. Thanks in advance for any help. Regards, Shepherdmoon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flipping Cell Data Horizontal/Vertical
"John Green" wrote in message ...
Copy the data and then use Edit|Paste Special. Select the Transpose option and click OK. -- Thank you!! Regards, Shepherdmoon John Green - Excel MVP Sydney Australia "Shepherd Moon" wrote in message om... Hello, I hope I can describe this correctly to see if there is an Excel macro already available: Is there a function or macro that can take a set of cells and "flip" it so that it runs perpendicularly to its original orientation? For example, if one has values in column A1 through A5, this macro would allow you to select that data, run the macro, and the resulting data would then appear in cells A1 through E1. (The reverse would also be possible.) This would help avoid having to retype, say, query column headers imported into Excel if one wanted those header names to run vertically instead of horizontally. Thanks in advance for any help. Regards, Shepherdmoon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving data from vertical to horizontal possition | Excel Worksheet Functions | |||
Cross Reference Vertical and Horizontal for Data | Excel Worksheet Functions | |||
Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
tranfere vertical data to horizontal tabel | Excel Worksheet Functions |