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!
|