video1.0<iframe src="https://www.loom.com/embed/febdfcac00744656a7acc3ea44dfb3de" frameborder="0" width="1672" height="1254" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>12541672Loomhttps://www.loom.com12541672https://cdn.loom.com/sessions/thumbnails/febdfcac00744656a7acc3ea44dfb3de-2f8b58a225813027.gif107.738In this video, I demonstrate two effective strategies for data grouping without using macros. The first approach involves using a pivot table, where I configured automatic refresh settings in the Valexo toolbar to ensure the data stays up-to-date. The second method utilizes the new Excel dynamic function called "group by," which allows for grouping by both employee and task columns, generating a dynamic array without the need for multiple columns. I also highlight the importance of using the new trim range syntax to avoid blank rows in the output. Please take a look at these methods and consider implementing them in your own work.