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!!!
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!!!