Using Power Query to Connect Tables for Reporting | Excel.TV

An Excel Joke to Start Off…

Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them.

And that’s what we’re doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.  

This week, I’ve simplified it all using a left outer join. This is a really cool feature that lets you treat Excel like a database. You can a very similar use of joins in Szilvia’s video, by clicking here.

Watch the entire video to see how I join two different tables using name as the primary key! 

Get the Download File

Get the file by clicking this link.

What do you think? How do you connect tables?

Let us know in the comments.


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • I use this function pretty much daily. I’ve always heard that it is better to use power pivot though. The problem I have though with power pivot is that if there are more than one of the same value in each table, it doesn’t work. So I just use the merge query capability in get and transform. I never have any problems with it.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.