With the data in A1:A2500, put this in B1:

=OFFSET($A$1,COLUMN()-2+3*(ROW()-1),0)
And drag across to D1

Then select b1:d1 and drag down until you run out of data (around row 834)

This assumes that each group has exactly 3 cells associated with it.

CTCrow wrote:

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.

--

Dave Peterson