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

use PowerQuery

Power Query for

• Excel 2010 Pro Plus or Excel 2013 Pro Plus can be downloaded as free add-in from MS site (choose correct version). I suggest Power Pivot also
• Excel 2016 or Excel 365 is built-in, aka Get&Transform
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What PowerQuery is? see here: Getting Started with PowerQuery (Get&Transform) in Excel