Actually quite easy using the Copy/Paste Special options

What your trying to do is move the data from rows to columns.
Simply select all of the rows of data you wish to move/copy. In your
examply you have 6 rows (select all rows).

From the Task Bar select Edit - Copy

Open a new sheet and position your cursor in cell A1 of the sheet

From the Task Bar select Edit - Paste Special and select the Transpose Box
appearing in the bottom 3rd of the options available

Select OK

Your Done

What was in Cells A1:A6 now appears as column headers in Columns A1:F1

I use this option frequently.

"rudyh" wrote:

> I have a sheet in this form:
> name1
> address1
> city1
> name2
> address2
> city2
>
> etc. for ~ 5000 names
> I would like to move all the names to one column, addresses to the next
> column and cities to the 3rd column so ai can sort the data on the names.
> How could I do this in an easy manner?
>
> Thank You in advance.
> Rudy
>