Most valuable professional
  • Hot Topics

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 ID#11111 ID#11112 ID#11112 ID#11113 ID#11113 What I am trying to do Product Name Manufacturer Name Supplier Name Distributor Name Product Name Manufacturer Name Supplier Name Distributor Name Product Name Manufacturer Name Supplier Name Distributor Name Any and all help and suggestions would be GREATLY appreciated!

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

This thread is current as of October 7, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel