The easiest way is probably with simple copy and paste. Choose all of the
information on one of the worksheets and use Edit | Copy and then go to the
end of the list on the other worksheet and use Edit | Paste.

You can then, if you want, choose all of the data and use Data Sort to truly
merge the lists aphabetically.

If you want to preserve both of the original lists, just copy both lists to
an empty sheet.

"Mike" wrote:

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

<List 1
Name Info
Mike Good Guy

<List 2
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

<List 3
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?