Transfer columns in one column

Your request is not clear.
You said you want to transfer in to a single column, but you have 3 columns in the output sheet. I followed your sample and did 3 columns only. When you run the code, you get the output in new sheets.