I have 19000 rows of data and need to consolidate every two lines ont
one, starting at row 8. So that the data on rows 8 and 9 is all on ro
8. The data goes up to column M at the moment.

I am stumped how to do this using a macro.

Any ideas?

Thanks

Bria

--
Message posted from http://www.ExcelForum.com