Excel - Multiple rows to multiple columns based on one reference

Tim Holyomes
Tim Holyomes used Ask the Experts™
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 |
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try attached.
Press the button to run the macro.


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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial