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

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

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