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

 

Simplify your shipping (and save) with ShippingEasy. Start your 30-Day Free Trial.

 


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

If you have problems that require extra assistance, feel free to reach out to our team.

Anyone can post questions in the comments, to the left, and the ShippingEasy Customer Success team will gladly assist.


ShippingEasy accounts on a paid plan will find additional resources in the upper left corner in app.

1-512 | Email | Chat

Fully registered accounts may email, call, or chat with our team.
Trial accounts may email or call.

Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing