Flipping Cell Data Horizontal/Vertical

  • Thread starter Thread starter Shepherd Moon
  • Start date Start date
S

Shepherd Moon

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
 
Copy the data and then use Edit|Paste Special. Select the Transpose option and click OK.
 
Back
Top