Assuming that your values start in cell A2, use these formulas in cell:

B2 = A2
C2 = A3
D2 = A4

Then copy B2:D4, and paste to B5:D????, where ???? is the row with the last
entry.

Then copy columns B:D, and paste special values, then delete column A and
sort A:C based on column A, which will make all the blanks go away.

HTH,
Bernie
MS Excel MVP



"rudyh" <rudyh@discussions.microsoft.com> wrote in message
news:82B4F41C-5EC0-4034-96E1-D565DA6E2A22@microsoft.com...
>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
>