I’m trying to create a list of SKU’s by combine attributes from three other list together.
Attribute 1 - Color
Attribute Name
SKU code
Finish
Attribute Name
SKU code
Finish
1
Blue
Blu
Matte
Glossy
2
Red
Red
Matte
Glossy
3
Green
Gre
Semi-Gloss
There are no rows in this table
Attribute 2 - Finish
Attribute Name
SKU Code 2
Attribute Name
SKU Code 2
1
Matte
1
2
Glossy
2
3
Semi-Gloss
3
There are no rows in this table
Attribute 3 - Item
SKU Code 3
Color
SKU Code 3
Color
1
Table
Blue
2
Chair
Red
Green
Blue
3
Desk
Blue
Green
There are no rows in this table
How do I make this table automatically populate and stay up to date so if a color become available in a new finish or we stop making chairs in a certain color the list of SKUs can stay upto date?
List of Possible SKUs
Final SKU
Item
Color
Finish
Final SKU
Item
Color
Finish
1
Blu1Table
Table
Blue
Matte
2
Blu2Table
Table
Blue
Glossy
3
Blu1Desk
Desk
Blue
Matte
4
Blu2Desk
Desk
Blue
Glossy
5
Gre3Desk
Desk
Green
Semi-Gloss
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (