Excel 365 Tutorial: Combine Tables with Different Column Order

Combine two tables with different column layouts with 1 formula! Timecodes: 0:00 - Intro 0:20 - Reference table on new worksheet 0:39 - CHOOSECOLS() - Change order of columns 1:12 - XMATCH() - Match the headers from tables 1:55 - VSTACK() - Combine the two tables 2:38 - UNIQUE() - Remove duplicate results from new table Visit our business homepage: https://mycostpro.com