Tim Holyomes
asked on
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 |
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 |
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please close the question by accepting the answer.
ASKER
You've saved me many hours of work!