Flipping Cell Data Horizontal/Vertical

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
 
J

John Green

Copy the data and then use Edit|Paste Special. Select the Transpose option and click OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flipping Data 4
Excel 2013 Merge Data 2
Macro to Combine Data from Multiple Sheets with Cell References 4
MACRO THAT BUILDS ON ANOTHER MACRO'S DATA 6
macro to copy data and paste to a new sheet in next available cell 2
copy cell formula and adjust column spacing 1
moving data from one cell to another 0
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2

Top