On Tue, 24 Aug 2010 17:35:30 -0700 (PDT), Pete_UK
wrote:

Copy/paste all the lists under one another as you describe. Make sure
you have a header in the first cell (eg "WORDS"), then highlight all
the data and the header. Click on Data | Advanced Filter and in the
pop-up click on Copy to another location, put C1 in the Copy to box,
and check Unique values only. Click OK and your reduced list will
appear in column C - you can delete columns A and B if you don't need
them.

That worked perfectly. Thanks. Now I have my merged list with no
duplicates.

I'm not sure what you want to do in the second part of your post.

I want to create a table with N rows and M+1 columns. Column A will
have the master list from the step above.

Column B will have a "1" in each cell next to a word in Column A that
is also in the first list and a "0" everywhere else. Column C will be
the same for the second list and so on.

If my original lists we

1 2 1 5
3 4 2 6
5 6 3 7
7 8 4 8

The new table would look like this:

1 1 0 1 0
2 0 1 1 0
3 1 0 1 0
4 0 1 1 0
5 1 0 0 1
6 0 1 0 1
7 1 0 0 1
8 0 1 0 1

Do you have any magic for that?

Running Excel 2007.