+ Reply to Thread
Results 1 to 3 of 3

Combine 2 tables of data into 3rd table

  1. 03-24-2014, 11:01 AM #1
    rdingley
    rdingley is offline
    Registered User
    Join Date
    10-16-2013
    Location
    Coventry, England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Combine 2 tables of data into 3rd table

    Hi all
    I have data tables LIST 1 (M360:Q489)
    LIST 2 (M217:Q346)
    What I would like to do is, combine these list together in LIST 3 (M500:Q529) so that, when the first row of blank data is found in LIST 1, then data is picked from LIST 2 until all data has been combined
    All lists are 130 rows * 5 columns

    Any help appreciated thank you
    Last edited by rdingley; 03-24-2014 at 11:03 AM.
    Reply With QuoteRegister To Reply
  2. 03-30-2014, 11:47 AM #2
    Mandy11
    Mandy11 is offline
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: Combine 2 tables of data into 3rd table

    Sounds like a vlook-up to me. Attach an example
    Reply With QuoteRegister To Reply
  3. 03-30-2014, 03:08 PM #3
    rdingley
    rdingley is offline
    Registered User
    Join Date
    10-16-2013
    Location
    Coventry, England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Combine 2 tables of data into 3rd table

    Thanks for looking Mandy11.
    My apologies for wasting your time, but I managed to solve this one now, and forgot to set as SOLVED
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine multiple tables into one master table
    By nemoo in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-24-2014, 12:33 PM
  2. Combine different tables in one table from selected files
    By forfiett in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-21-2013, 06:07 PM
  3. How can I combine multiple tables into one pivot table?
    By crsport3 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-21-2013, 02:53 PM
  4. How do you Combine specific columns from 3 tables into new column of new table
    By R.Taylor.B in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-30-2012, 02:21 PM
  5. How to combine multiple pivot tables into one table, vlookups?
    By bigxshowx in forum Excel General
    Replies: 1
    Last Post: 12-15-2009, 10:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1