Moving Data

Could any help on how to transpose 5 or 6 rows in one colum of data into 1 row of data, Ok that is the easy bit, I have that much data that I was wondering if I could Automate or set up some kind of template to do this as I paste the data into the program. The program the data is coming from does not allow me to export I have to manually cut and past.


ThanKyou