Hi everyone,
I have a table that matches products sold together (product 1 together with the various product 2 results). In the excel file, product 1 information is that which was originally the row names in a matrix and product 2 was the original column names in a matrix. I transposed the columns so that the row products will show the matches in a table format. (However, after I prepared data to join it with this specific data, the joins literally only swops column names around and what was the "Row_" fields is named the "Col_" fields and what is supposed to be the '"Col_" fields is named the "Row_" fields as you can see in the attached Excel example. (The top sample is after the first join and this data is correct, but the second join changes the names as displayed in the bottom sample.) Does anyone know why the join tool does this?
Thank you for helping,
Rouche
