Hi everybody !

I copy in a one column some data , which are in different rows, with empty rows between data. I need code to put that data row by row without empty rows between data.
( I copy this data în another worbook, useing ,,Transpose,, .i select 1500 rows and cant be paste in 265 columns in Excel 2003.) .
That's why i need to comprime data in a few rows

Thank You so much.