Personally, I think this sounds like a really bad idea. I would leave the
data as is (presumably with a single row per record), to leave yourself the
flexibility of using it like a database, should you ever need to. I would
recommend that, if you need this type of layout, you create a mail merge in
Word to format the data as
<address1
<phone1
<address2
<phone2

"ad" wrote:

This is probably an easy one, but I have a spreadsheet with thousands of
lines & I need to move column B (phone numbers) into column A (addresses) so
that the rows are alternating addresses & phone numbers:

NOW:
address1 phone number 1
address2 phone number 2

I WANT:
address1
phone number1
address2
phone number2

thanks in advance for your help!