Say that these names and addresses are all in Column A on Sheet1.
*NO* spaces (empty cells) between entries
Say you want to start your new data configuration on another sheet.

Enter this formula *anywhere* on the new sheet:

=INDEX(Sheet1!$A:$A,3*ROWS($1:1)+COLUMNS($A:A)-3)

Drag across 2 columns to copy, to a total of 3 columns.

Then select those 3 cells, and drag down the 3 cell *selection* as far as
needed.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"CTCrow" wrote in message
...
I have some data that is all in order in a column, like this:

name 1
street 1
city 1
name 2
street 2
city 2
name 3
street 3
city 3

and i like to move the cells to look like this:
(Each in it's own cell for sorting)

name 1 street 1 city 1
name 2 street 2 city 2
name 3 street 3 city 3

without having to drag every single cell one at a time. I have over 2,500
cells and it would take too much work. My son is charging mee too much to do
it.(i should start charging him for rent and food)

What options do i have?

all help is really apreciated.