Results 1 to 5 of 5

Create Rows based on two tables

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    21

    Create Rows based on two tables

    Hi ,

    Need help in consolidation of two tables into a single table

    Ex: Table 1 has following entries
    A 1 MCD
    A 2 KFC
    A 3 Dominoes
    B 1 Ford
    B 2 BMW
    C 1 Paris

    Table 2 has following entries
    A 1 MCD
    A 2 KFC
    B 1 FORD
    B 2 BMW
    D 1 France

    Output table should be created as follows
    A 1 MCD 1 MCD
    A 2 KFC 2 KFC
    A 3 Dominoes
    B 1 Ford 1 Ford
    B 2 BMW 2 BMW
    C 1 Paris
    D 1 France

    I have around 40k entries that needs to be done in this way. Please help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create Tables Based from Raw Data
    By paula.mccall in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-20-2021, 04:33 PM
  2. [SOLVED] Create userform with dependent combobox based on different tables
    By awoolfe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2021, 11:20 AM
  3. Help! Want to create a leaderboard based on rankings in several different tables.
    By Tallulah2408 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2017, 05:26 PM
  4. Insert rows/create tables based on user input?
    By boningsloots in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2017, 07:46 AM
  5. Create multiple tables based on data in a spreadsheet
    By ablits1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2017, 12:52 PM
  6. Macro to create sets of tables based on number input
    By anubis512 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2014, 01:43 PM

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