Excel - Left Join Tables from Multiple Sheets Like in SQL - Power Query Tutorial

Описание

Learn how to SQL left join multiple tables from multiple sheets in Microsoft Excel using Power Query. This tutorial outlines differences between using VLOOKUP and SQL like join, shows how to choose join types, like left, right, inner and full, as well as how to concatenate columns in Power Query.

Download Power Query for Excel 2010 & 2013.
https://www.microsoft.com/en-us/download/details.aspx?id=39379

#excel #sql