Excel: HELP-Rearranging data into columns


Good Morning All, So I have a lot of data in rows that I need to rearrange and organize into columns. Transpose doesn't quite fulfill my needs and was hoping to find a way to write a formula that will capture what I am trying to do. I will include an example of what I am looking for below. So here is what I have right now:

ID#11111 Product Name Manufacturer Name Supplier Name Distributor Name
ID#11111 Product Name Manufacturer Name Supplier Name Distributor Name
ID#11112 Product Name Manufacturer Name Supplier Name Distributor Name
ID#11112 Product Name Manufacturer Name Supplier Name Distributor Name
ID#11113 Product Name Manufacturer Name Supplier Name Distributor Name
ID#11113 Product Name Manufacturer Name Supplier Name Distributor Name
What I am trying to do
Product Name ID#11111
Manufacturer Name
Supplier Name
Distributor Name
Product Name ID#11112
Manufacturer Name
Supplier Name
Distributor Name
Product Name ID#11113
Manufacturer Name
Supplier Name
Distributor Name
Any and all help and suggestions would be GREATLY appreciated! Thanks, all!


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of October 07, 2015.


For more resources for Microsoft Excel