Multiple transpose of linked categories

[chickenlicken]

I have data arranged across columns and I am trying to consolidate these columns into single categories with the data in rows.  

In the example data here I would like to consolidate Colour 1 and Colour 2 into one column - Colour, and Specific Colour 1 and Specific Colour 2 into one column, Specific Colour.  I can't work out how transpose Specific Colour while keeping the link to Colour. 

Any help much appreciated. 

[afv2688]

Hello @chickenlicken,

Would this be ok?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[OllieClarke · Accepted solution]

Hi @chickenlicken is this what you're after?

Ollie

[chickenlicken]

Thanks! Exactly what I was after