View Single Post
  #1   Report Post  
ad
 
Posts: n/a
Default consolidating two columns

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!