Most valuable professional
  • Hot Topics

Excel Code to cut all column values & place them under one column

Hi MrExcel I have a large Excel sheet with common row headers but with close to 12 columns with different values. As the row headers are the same, I need only one column under 1st of the 12 with all column values under it. Currently, I copy the common rows & columns & paste them downwards 11 times, then cut all values in each column & paste them downwards, again 11 times so that am left with ONLY ONE column for quick sorting. ITS TIRESOME though safer for me. How can I simplify this with a code? HELP!!!

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

This thread is current as of March 13, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel