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): https://www.xlconsulting-asia.com/youtube-files.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