Use GROUPBY with multiple fields. Rows, values & aggregations in Excel

With PivotTables its easy to add the columns you like via checklists and drag & drop, but with the new GROUPBY and PIVOTBY its a bit harder. This is part of a series of videos about these functions, I showcase here how to add fields to rows, values, and even multiple aggregations on the same field. It all uses the handy HSTACK function on top of GROUPBY and PIVOTBY.

Download the workbook here (labeled GROUPBY PIVOTBY complete guide) by entering your email here: https://www.xlconsulting-asia.com/socials.html

PivotTables vs GROUPBY blog: https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2024/excels-groupby-and-pivotby-functions

Videos in the series
GROUPBY / PIVOTBY for beginners: https://youtu.be/fYBdA4fLT1k
GROUPBY / PIVOTBY with multiple columns non consecutive etc. https://youtu.be/0CifD6GMud8
GROUPBY / PIVOTBY % of parent/total: https://youtu.be/9_40INp5jtc
Combine text and custom functions: https://youtu.be/Dptj7aEY3IM
Interactive charts & slicers: https://youtu.be/7IJ5xhIqwNY

00:00 Introduction
00:20 Consecutive columns
00:57 Headers, totals, filters
02:09 Field relationship for non hierarchal dates
03:49 GROUPBY non consecutive cols
04:56 Non consecutive with multiple values
06:06 Multiple aggregations of same field
07:02 PIVOTBY with multi cols

Видео Use GROUPBY with multiple fields. Rows, values & aggregations in Excel канала David Benaim