Bite the apple, switch to MS Access, and STRUCTURE YOUR DATA, then copy/paste or retype everything.
Kees
Windows XP Home Edition; Excel 97 SR-2
I have 50 plus Excel Spreadsheets with Contact Name, Address, etc. I use Advance Filter to find duplicates. Now, how can I merge?
HAVE:
Contact Company Phone City State
John May ABC, Inc. 555-555-1212
Contact Company Phone City State
John May ABC, Inc. York NE
WANT:
Contact Company Phone City State
John May ABC, Inc. 555-555-1212 York NE

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic