Originally Posted by
Mondeo Man
PON's/Shings' method is the best one, to ensure the order is maintained and nothing is deleted.
I sincerely hope some of you guys offering solutions dont actually work with excel
If it was for me, I would do a VBA script, which is easiest way for me