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

[@ebenezerasare9934]

you are the king of Groupby, pivotby

[@learnspreadsheets]

Hehe thanks so much! Another vid coming soon 😃

[@IvanCortinas_ES]

Great tutorial, David. Thank you!!!

[@learnspreadsheets]

Yay! Glad its helpful, check my series on GROUPBY / PIVOTBY for more tips on them!

[@kebincui]

Brilliant! Thanks David 👍

[@learnspreadsheets]

Glad you like it!

[@siddhantbhuwania8982]

How to get this in matrix format like in a normal pivot table we can add two fields in rows?

[@learnspreadsheets]

Hello, the example you ask for is mentioned in the video, using PIVOTBY and then HSTACK in the "row fields" to combine two columns. This article explains in text format with a downloadable workbook too: www.icaew.com/technical/technology/excel-community/excel-community-articles/2024/excels-groupby-and-pivotby-functions

[@siddhantbhuwania8982]

@learnspreadsheets Thanks a lot for sharing. I will check & see if it works as per my requirement