can't work this one out can you rotate the data in a spread sheet

Colloms to rows ie
From:
Name
Adress
Town
Post code

To
Name Address Town Post code

Eash item is in a single cell

Help!!
--

Thanks Bruce

Yes, use copy and Paste SpecialTranspose

"Bruce" wrote:

can't work this one out can you rotate the data in a spread sheet

Colloms to rows ie
From:
Name
Adress
Town
Post code

To
Name Address Town Post code

Eash item is in a single cell

Help!!
--

Thanks Bruce

Yes you can. Copy the information then right click and paste special
and click transpose.


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=475621