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