{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/febdfcac00744656a7acc3ea44dfb3de\" frameborder=\"0\" width=\"1672\" height=\"1254\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1254,"width":1672,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1254,"thumbnail_width":1672,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/febdfcac00744656a7acc3ea44dfb3de-2f8b58a225813027.gif","duration":107.738,"title":"Effective Data Grouping Strategies in Excel 📊","description":"In 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."}