When I was working as a HR data analyst, one task I would do every week is combine data in two different tables. In this video, let’s look at two ways to solve the problem. One using formulas and another with Power Query . Both methods are really simple to set up and will save you TONS of time in the long run.

Video topics
==============
0:00 – Combining two tables in Excel – the problem
1:15 – Using lookup formulas to combine tables (with XLOOKUP)
2:18 – Using VLOOKUP to combine tables
3:04 – Using Power Query to join two tables (merge queries)
6:25 – Loading merged data to Excel

Sample workbook:
==================

Grab the sample file from this link if you want to follow along or practice.
https://chandoo.org/wp/wp-content/uploads/2022/07/combine-tables.xlsx

‍ Learn more :
===============

YOUTUBE VIDEOS:

on Power Query (complete tutorial, 80 mins, 260k views) – https://youtu.be/PiFAa_jjaEI
on XLOOKUP (intro, 10 mins, 280k views) – https://youtu.be/DDlZXXEI1bU
on combining data from Excel files – https://youtu.be/SGzegma9bdY

‍ COURSES:

Power Query mini-course (2 hours, full PQ with many practical examples) – https://chandoo.org/wp/power-query-power-course/
Lookups mini-course (1 hour, 13 lessons) – https://chandoo.org/wp/lookups-for-data-analysis/
FULL Excel (24+ hours, 100s of examples) – https://chandoo.org/wp/excel-school-program/

~

More Power to You

PS: Scene from The Dark Knight at 0:33

#Excel #powerquery

Please take the opportunity to connect and share this video with your friends and family if you find it useful.