Excel 2007 : Merging Duplicate Rows

[bonnie685]

Hello
I have an issue that I am sure is very easy to solve, but I do not know how to do it.
I am working on Registration for a huge event that is happening this weekend and I need to get all of the badge data together.
The information is coming from 4 different spreadsheets. The First Name, Last Name and the Country the person is from is contant on every spreadsheet, but not all people are partisipating in all things. I need to merge the data so all the appropriate fields are in one row per person so we can finish the Mail Merge in Word for the badges to print. Can anyone tell me how to do that?? If i can get help on doing this, it would be greatly appreciated!! I can send you the doc if needed.....

[carsto]

posting sample workbook(s) would help.