Results 1 to 5 of 5

Reconciling and merging 2 tables with almost identical 1st two columns?

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    3

    Reconciling and merging 2 tables with almost identical 1st two columns?

    Hi,

    I have 2 Excel tables with information about a datamodel. (Excel 2003, by the way)
    The sheets have almost the same 1st two columns: data table name and data column name, and then different columns for different information.
    Table #1 with 2 extra columns indicating foreign key and comment and table #2 with 2 extra columns indicating data type and data lenght.
    Most rows (identified by data table name and data column name) are in both tables; however some rows are only in one table.
    I want to reconcile and merge those 2 tables into a single sheet with
    - all 8 columns and with one single row when a match can be found between table #1 and table #2 (based on identical data table name and data column name)
    - and, in between, the rows from either tables, which haven't found a match in the other table
    - all the while keeping the order by (first data table name and second data column name), which both tables already have.

    I hope I wasn't too complicated in my explanations ;-)
    Can anyone help me? Thx a lot!
    Last edited by dmaurer; 01-29-2007 at 01:27 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1