Rudy

If data is in sets of three as you describe and assuming in column A....

Enter this formula in B1 and copy across to D1 and down B,C and D until you
gets zeros.

=INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1))

Copy this range and Paste Special(in place)>Value>OK>Esc.

Delete column A.


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 13:14:59 -0800, "rudyh" <rudyh@discussions.microsoft.com>
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