mattcc1989
New Member
- Joined
- Dec 28, 2016
- Messages
- 2
I'm hoping someone would be kind enough to help me with an excel formula that i'm struggling to get my head around.
I have a spreadsheet of products e.g. column A = product name, B = Price, C = description, D = key features and so on.
Row 1 would be product 1, row 2 product 2 and so on.
I have around 300 products and want to create new rows which contain all possible combinations of products.
So that I end up with:
A = product 1 name, B = Price, C = description, D = key features, E = product 2 name, F = Price, G = description, H = key features.
Which is easy enough, but is there a way to automate every possible combination based on the product name?
So if I only had 4 product, the formula would create rows for each combination of products (but obviously keeping the name, price, descriptions etc.
product 1 | product 2
product 2 | product 3
product 1 | product 3
product 3 | product 4
product 1 | product 4
product 2 | product 4
Essentially what I'm trying to achieve is a comparison of all my different products, but each comparison needs to be on a single row.
Thanks
I have a spreadsheet of products e.g. column A = product name, B = Price, C = description, D = key features and so on.
Row 1 would be product 1, row 2 product 2 and so on.
I have around 300 products and want to create new rows which contain all possible combinations of products.
So that I end up with:
A = product 1 name, B = Price, C = description, D = key features, E = product 2 name, F = Price, G = description, H = key features.
Which is easy enough, but is there a way to automate every possible combination based on the product name?
So if I only had 4 product, the formula would create rows for each combination of products (but obviously keeping the name, price, descriptions etc.
product 1 | product 2
product 2 | product 3
product 1 | product 3
product 3 | product 4
product 1 | product 4
product 2 | product 4
Essentially what I'm trying to achieve is a comparison of all my different products, but each comparison needs to be on a single row.
Thanks