Most valuable professional
  • Hot Topics

Excel Combining columns into row

Here is the data I have: column 1 column 2 column 3 smith blue 4 smith green 3 smith red 4 jones blue 2 jones red 2 jones green 3 jones yellow 2 brown red 3 brown blue 3 etc. I need it to be like this: Column 1 column 2 column 3 column 4 column 5 column 6 etc. smith blue 4 green 3 red 4 jones blue 2 red 2 green 3 Thank you for the assistance.

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

This thread is current as of March 8, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel