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 |
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 |