Excel - Multiple rows to multiple columns based on one reference

Hi All,

I'm trying to tidy up a excel document  Sample.xlsx so that the rows under the column _category, are all in their own column rather than row.  There are a different number of rows for each product. Example of how it should look below.

I've tried vlookups and generally been scratching my head for an hour but can't figure out how to do it.

So it should look like:  

Products1 | simple | Products/Nozzles | Products/Nozzles/Manual | Brands/Quality |