Joining columns into Fewer columns and multiple rows

Ok, had a look, you want this option below:

Highlight all columns except the data and pivot, you'll then have to extract the info from the "Attribute" column name strings.

Give me a shout if you don't know how to do this.