How would I get the following table:


FRUIT SHOP1 SHOP2 SHOP3
RedApple 66
GrnApple 74 444 5
Pear 21 12
Peach 321
Orange 321 1

Into this.....

FRUIT SHOP QTY
RedApple Shop3 66
GrnApple Shop1 74
GrnApple Shop2 444
GrnApple Shop3 5
...

Thanks,

Adam.