The last part can be done easily with a pivot table.

The first part...not quite sure. Where is the information for hat and scarf coming from? Is there a table that you have that has the codes? If so, you can do a lookup.

If you have a sample file, that would help.