Sounds like the names, addresses etc. are in one column, not one row.

And I assume repeated many times down column A in sets of 9

Select B1 and insert 9 columns to the right of A, moving B data to K

Enter this formula in B1

=INDEX($A:$A,(ROWS($1:1)-1)*9+COLUMNS($A:B)-1)

Drag/copy across to J1 then drag B1:J1 down until you get zeros.

When happy, select the formulas range and copypaste special(in
place)valuesokesc.

Delete column A


Gord Dibben MS Excel MVP

On Tue, 9 Sep 2008 10:48:22 -0700, dianna
wrote:

I have no idea if this is possible, buy i have a spreadsheet of data with
names, addresses and phone numbers listed all in one row, Name at top,
address underneath that, city, state zip under that, and phone # under that,
with a total of eight lines underneath name.

In addition, in the columns, there is information in b1.

How do I move A2 into B1, A3 into c1, a4 into d1, a5 into e1, a6 into f1, a7
into g1, a8 into h1, then A9 becomes a2 or a3, and the original info in b1
just moves out to the side.