Transformar datos con la función AGRUPARPOR y SCAN - Excel 365

We continue performing data transformations using Excel 365 functions, in the style of Power Query. In this video, I show you again how it's possible, using Excel 365 functions, mainly GROUPBY and SCAN. If you have questions or comments about this case, please write to me in the comments section and I'll respond as soon as possible. Can you think of a case or one you'd like to solve? Then email me, and I'll be happy to help. Link to file: https://1drv.ms/x/c/18758b8130ccc5b5/... Website: https://www.powerexcelbi.com/ Channel: @impresionanteexcel LinkedIn: Gerson Pineda: linkedin.com/in/gersonpineda Email: [email protected]