Excel - Multiple rows to multiple columns based on one reference
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.
You've saved me many hours of work!