Aggregate Rows in Power Query with Group By

In this video, we aggregate rows in Power Query. Two examples are shown in the video, a simple Group By example, followed by an advanced Group By in Power Query that includes combining text in a single cell. You can aggregate tables when combining tables or files and also on performing merge queries. This video, focuses on how to aggregate rows using Group By in Power Query. Timings of the video. 00:00 - Aggregate rows in Power Query 00:50 - Import multiple tables from Excel 02:20 - Aggregate tables 04:18 - Basic Group By in Power Query 05:48 - Advanced Group By Power Query example 09:02 - Aggregate rows with text 10:37 - Text.Combine function to aggregate text 13:28 - Load to Excel as separate table on the same sheet Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel