Converting data in matrix form into a vector

I want to calculate the average of the top 20% for each category. I think I found a formula to do this but the data is in the wrong format for this.
Data looks somehow like this.
Blue 1 10 Tall
Red 2 15 Tall
Blue 1 20 Small

And I would like it look like
Blue 10 Tall
Red 15 Tall
Red 15 Tall
Blue 20 Small

Basically, the second column shows the number of times in which for example the value is blue, 10 and tall.
Is there any way to change the data?

Thanks

Thank you very much thats great