How can I merge different lists in Excel?

I have a number of mailing lists that were originally created using Excel. I
need to merge them into one list, but each list has different functions for
each column... how can I merge these lists or if all else fails, can I
somehow create another merged list in Word? Help... can't seem to get the
instructions through to my muddled brain so the Help section is not working
for me.

"Nancie" <Nancie @discussions.microsoft.com> wrote in message
news:[email protected]...
>I have a number of mailing lists that were originally created using Excel.
>I
> need to merge them into one list, but each list has different functions
> for
> each column... how can I merge these lists or if all else fails, can I
> somehow create another merged list in Word? Help... can't seem to get the
> instructions through to my muddled brain so the Help section is not
> working
> for me.

I think you will have to decide on what layout you want (i.e. what function
is in which column) and get each list into that format. It isn't nearly as
bad as it sounds as you can drag whole columns to wherever you want them.
Then you can just copy from each list and paste below the data in the
combined list.