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 |