how do I move data in prexisting rows to columns?

D

darryl

I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?
 
B

Bondi

darryl said:
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?
Click to expand...

Hi Darryl,

Maybe you can use the Transpose option under Paste Special.

Select your data -> Edit -> Copy.
Then select where you want your data and go to Edit -> Paste Special
and tjeckmark Transpose and press OK.

Regards,
Bondi
 
Top