Excel

[Bruce]

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

[Coltsfan]

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

[bigwheel]

Yes, use copy and Paste Special>Transpose

"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