I have a set of product attributes, each attribute belongs to a group, example:

Product - T Shirt

The attributes would be

Size > Medium

Cut > Round Neck

Color > Green

What I would like to do is have ONE multi select column with all the attributes in. The output needed would be split into separate columns like so:

Column 1:

Attribute 1 name : Size

Column 2:

Attribute 1 Value: Medium

Column 3:

Attribute 2 name: Cut

Column 4:

Attribute 2 Value: Round Neck

Etc…

The multi select needs to be able to be in any order, I have made another table with each attribute and it’s attribute name and then used a LOOKUP to send that back to the main sheet. This returns a string of 3 attribute names.

Is there a way to take the first value in the string and return it’s attribute name?

I know this seems like doing it the hard way but it has to conform to something our website can digest, and that is:

Attribute 1 name

Attribute 1 value

Attribute 2 name

Attribute 2 value… Etc. It doesn’t allow for an empty first attribute, that’s why I need them to be a bit flexible

Thanks!