Quote Originally Posted by mc12345678 View Post
To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...

Thank you for the reply. It worked the way I did it but I think the way you showed is faster.

My shop has all 1380+ items listed and it imported without a hitch. Thanks again :) Below is a link to my store.

http://www.southerncrossemporium.com.au/