Link to home
Start Free TrialLog in
Avatar of Tim Holyomes
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 |
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tim Holyomes
Tim Holyomes

ASKER

Thanks Ejgil, this is exactly what I wanted and works perfectly.  

You've saved me many hours of work!
Please close the question by accepting the answer.