+ Reply to Thread
Results 1 to 2 of 2

merge tables

  1. #1
    Registered User
    Join Date
    02-24-2017
    Location
    london
    MS-Off Ver
    OFFICE 365
    Posts
    79

    merge tables

    hi i have 2 tables in the same row with list of vehicles on but i need to merge the list into one so i can use the third list as a source for a drop down list i have attached a mock up of what the row looks like
    is there anyway of doing this ????

    Regards
    Steddas
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: merge tables

    use PowerQuery

    Power Query for
    Attached Files Attached Files
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ 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. Help with Pivot Tables to merge two tables
    By scrawl.to.me in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2015, 06:01 AM
  2. Need Help looking up 2 different tables to merge
    By mgabes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2014, 09:31 AM
  3. [SOLVED] How to merge 2 tables
    By Denlahti in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-11-2014, 04:42 PM
  4. Merge two tables in a new one
    By emarz in forum Excel General
    Replies: 7
    Last Post: 04-06-2011, 07:14 AM
  5. [SOLVED] HOW TO MERGE TWO TABLES
    By Bill Vogel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  6. [SOLVED] HOW TO MERGE TWO TABLES
    By Bill Vogel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] HOW TO MERGE TWO TABLES
    By Bill Vogel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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