Switch row with column?

J

jason57gizmo

Hello guys, im very new to excel, and im trying to learn. I cant seem
to figure out how to switch my chart around. I have a list of
companies on the top, and down the left i have a list of locations.
How can i make the locations go on top, and the companies down the
left?
 
D

Dave Peterson

Depending on the number of rows you're using--since there's only 256 columns to
work with.

Select your range to Transpose.
find a nice open spot that doesn't touch that original range (a new sheet???)
Edit|paste special|check the Transpose box and hit ok.

There's also a worksheet function you could use:

=transpose()

Say you want to transpose A1:B5, you could select C1:G2 and type:
=transpose(a1:b5)
but hit shift-ctrl-enter to do the work.
 
Top