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.