+ Reply to Thread
Results 1 to 3 of 3

Combining recordings from multiple tables

  1. #1
    Registered User
    Join Date
    07-26-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    10

    Combining recordings from multiple tables

    Hi everyone!

    I have a sheet where there are multiple tables in the sheet 'Raw Data'.

    What I want to do:


    Have a master table on the same sheet, which pulls the records for i.e Builder and the associated information in the row into the master table.



    Would prefer to do this by formula if possible. I am playing with Index Match to no avail.

    Thanks for your help and enjoy the rest of your week!

    Alex
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Combining recordings from multiple tables

    1) In I7 enter this formula and copy down as needed
    =A7&COUNTIF($A$1:$A7,$A7)

    You can hide this column if you wish.

    2) In K7 change the entry to Builder1, then grab the lower right corner of K7 and drag town through Builder11.

    3) Repeat that process for Plumber1-11, etc.

    4) The INDEX/MATCH formula in L7 would then work:
    =INDEX(B:B, MATCH($K7,$I:$I,0))
    ...formatted as currency, then copied down and across the table to pull in all the values.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-26-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    10

    Re: Combining recordings from multiple tables

    thankyou so much for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining Separate Tables With Multiple Values
    By Killericon in forum Excel General
    Replies: 15
    Last Post: 12-14-2020, 12:33 PM
  2. Replies: 4
    Last Post: 07-25-2017, 03:49 PM
  3. Combining multiple tables into one table
    By NDmad in forum Excel General
    Replies: 1
    Last Post: 07-20-2016, 03:48 PM
  4. Replies: 1
    Last Post: 09-09-2013, 10:20 AM
  5. Combining Multiple Tables in one worksheet into One Table
    By rhiminee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2013, 11:06 AM
  6. Combining multiple access tables
    By terreese in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 AM
  7. Combining Multiple Tables
    By fervorking in forum Access Tables & Databases
    Replies: 4
    Last Post: 06-24-2011, 10:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1