Excel: Split & Group Data with Power Query

In this video, we're given a list of employees tagged with attended events, and the goal is to determine event attendance counts as efficiently as possible. We start by loading data into Power Query from the Data tab. Focusing on the tags column, we split it by a comma and space delimiter, creating distinct rows for analysis. Utilizing the "Group By" function, we aggregate attendance counts for each event. Closing with "Close and Load," we produce a concise, insightful report ready for HR.
Power Query's efficiency shines, demonstrating its capacity to streamline complex data tasks in Excel.

[dankim]

I just heard power query today and I can't believe the years I wasted working harder with worst results.... This stuff is amazing!

[kendesmarais]

Thanks for showing that! One suggestion, you move through it so fast that I can’t see what you are doing. Slow it down just a tad. Thanks!