Consolidating 2 columns excel

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 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!There are two situations in which you might need to merge two columns of data in Excel 2013.If you've imported two columns of data from separate sources, you might want to combine them into a single column without linking the values themselves.

Now sort the whole thing on the helper column "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!For many Microsoft Excel users, combining two columns into one can be an especially helpful function.If you have a list of names with one cell containing a first name and one cell containing a last name, you might want to merge them into one cell, where the first and last name appear together. Start with the first row of data and insert a 1 in the helper column. If your data is in columns A&B, insert a new column A.

Leave a Reply