Consolidate Spreadsheets

Giganews Newsgroups
Subject: Consolidate Spreadsheets
Posted by:  Mike
Date: Mon, 8 May 2006

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?