Hi,

I am trying to write a macro that select "Sheet 1" and copy certain data from single row (consist of multiple columns) and paste in single column (with stacked rows) in "sheet 2". It definitely sounds like simple transpose but its lot more complicated than simple transpose. I have attached an example excel sheet to my post. In the sheet I just showed a range from A:Y but actual data range is much longer and unknown. Therefore, macro should identify the range and copy into a single column. Any help is greatly appreciated.

Thanks
Aroni


Book1.xlsx