★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post & download the example file★
https://exceloffthegrid.com/power-query-group-by/
★ About this video ★
In Excel, there are many ways to group and summarize data, and in Power Query Group By performs this task similarly to Excel functions, but with a slightly different purpose. In Excel, we generally summarize to display a result; however, in Power Query, we summarize to reduce data to the optimal granularity level. The Power Query Group By transformation is simple yet powerful. So, let's take a look at how we can use it.
0:00 Introduction
0:52 Group By views: basic and advanced
2:06 Summarize Data: Example #1
2:56 Summarize Data: Example #2
4:08 Summarize Text
6:02 All Rows option
6:55 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel #PowerQuery