Just to clarify,

is the data in sheet1 in orderly manner and what do you mean about sheet2?
How does the data need to be on the sheet2?

Rgrds,
Kristiina

--
I help with Excel and PowerPoint
Office ToDo
http://www.officetodo.com