I have the following situation:
1 column reflects product IDs and the other column are attributes of the product like color, size, etc.
I have the following table:
I have created new columns for each attribute but the result looks like this:
I need to transform this table in the following format:
I am not sure if a self-join on the attributes column and based on the Product IDs is the right solution here. If yes does anyone know how to do it?
If not then is there a better solution?
Thanks for the feedback!