Switch row with column?

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?

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.

jason57gizmo wrote:
>
> 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?
>
> --
> jason57gizmo
> ------------------------------------------------------------------------
> jason57gizmo's Profile: http://www.excelforum.com/member.php...o&userid=30700
> View this thread: http://www.excelforum.com/showthread...hreadid=503627

--

Dave Peterson