Follow

How to: Merge multiple columns of data in Excel without losing any data

Created:   |   Updated:

Many shippers sell products on a platform that does not integrate directly with ShippingEasy. For these orders, uploading a CSV file is the fastest way to create orders in ShippingEasy.

You can quicken this process without losing any of the data by merging multiple columns - such as "Item Descriptions" - so that they can all map to one field. 

If your CSV file is in Excel, follow these steps:

  1. Insert a new column where the data will be stored.
    Item_Description_-_Insert_Column.png
  2. Name the first cell of the new column.
  3. Add the Formula
    In this example we use =F2&" "&G2 as we are merging the data from these two columns:
    Item_Description_-_Insert_Function.png
    Please note the following:
      • The letters, such as "A", "B", etc needs to reflect the letter of the columns that will be combined. 
      • The number "1", etc needs to reflect the number of the row that is being referenced.
      • There needs to be a space in between the quotes, which will ensure that the data is merged with a space between the values.
  4. Hit enter and the data will now be merged for the one row or entry.
    To copy/paste the formula for all rows/entries:
    Item_Description_-_Drag_Formula.png
      1. Select the cell with the formula and copy.
      2. Hover the cursor over the bottom right corner of the cell to display a "+" symbol.
      3. Click here and hold the mouse while dragging down the cell to the last row/entry.
      4. This should auto calculate for all the cells.  If not, go to "Formulas" and on the right there should be a button that says "calculate sheet".
  5. Now all the data has been merged into one column that can be mapped to a single field using the CSV upload tool in ShippingEasy!
    Item_Description_-_Merged_Values.png

 


Related articles:

CSV Order Uploads: Column mapping - required fields & explanations 
How to: Check CSV uploads for duplicates and delete them
How to: Set up a CSV store

Comments

Please sign in to leave a comment.

Community browse

COMMUNITY FORUMS

Questions & Answers

Issues & Bugs

Beta Feedback

FEATURE REQUESTS

Productivity: Features, Interface & Settings

Partners: Integrations, Carriers & Stores

Shipping: Orders, Labels & Shipments

Inventory: Products, Purchase Orders & Suppliers