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