re-organising a table of data

[Tim]

Can anyone help me generate code to automatically transfer this: -

MATERIAL Storage Orange Apple
flour Ambient x x
Water Variable x x
Yeast Refrigerated x x
Salt Variable x x
fats Ambient x
Vinegar Ambient x
Cereals Ambient x
extracts Ambient x


to this (in this case for the 'Apple' column): -

Ambient Refrigerated Variable
===== ======== ======
Flour Yeast Water
Vinegar Salt

ie, on a different sheet, the different storage states become header rows
and only the materials with 'x's in the apple column are listed below the
appropriate column. i can achieve this in a pivot table, so maybe that
should be part of the solution (it all forms part of an automated package)?

thanks for any help,

tim

 

[Tim]

sorry - my first table didn't look like a table - hopefully this is more
clear...

MATERIAL Storage Orange Apple
flour Ambient x x
Water Variable x x
Yeast Refrigerated x x
Salt Variable x x
fats Ambient x
Vinegar Ambient x
Cereals Ambient x
extracts Ambient x