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

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:

Insert a new column where the data will be stored.
Name the first cell of the new column.
Add the Formula
In this example we use =F2&" "&G2 as we are merging the data from these two columns:

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.

Hit enter and the data will now be merged for the one row or entry.
To copy/paste the formula for all rows/entries:

Select the cell with the formula and copy.
Hover the cursor over the bottom right corner of the cell to display a "+" symbol.
Click here and hold the mouse while dragging down the cell to the last row/entry.
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".