I have some information in the following format:

Class 1 Class 2 Product Name
Dry Yellow Leaf 1
Wet Green Leaf 2
Dry Yellow Leaf 3
Wet Yellow Leaf 4

And I'd like to find a way of fomatting so that it is in a chart format like so:

Class1
Dry Wet
C Yellow Leaf 1 Leaf 4
L Leaf 3
A
S Green Leaf 2
S
2

I've tried Pivot Tables, but I don't know much about them and so I couldn't get it to do this - I could only get it to count how many values were in the category, which while useful, isn't what I want.

Could anybody help?

Many thanks,

Chris