Power Query - How to Count Unique Values (simple example)

📬 Get good at automations: https://www.gotsheet.xyz/c/gotsheet-youtube Quickly count unique values in a column that contains comma-separated data—like movie genres or tags—using Power Query in Excel. 🚀 Most people try to use UNIQUE() or FILTER() functions, but they're cumbersome when values are grouped inside a single cell. This video shows a clean, no-code method to split, trim, and count every distinct value in just a few clicks. You’ll learn how to: - Import your dataset into Power Query - Split cells into rows using a delimiter - Trim extra spaces for clean results - Group and count unique values - Export back to Excel as a connected table Perfect for anyone managing messy datasets or needing to do fast, accurate data cleaning and categorization. ➕ Want to learn how to do this with formulas instead - https://youtu.be/e1LQnye12-E 📌Get 20% off your first 3 months of beehiiv - https://www.beehiiv.com/partners/got-sheet?via=eamonn 🛠️ Tools I used: https://www.gotsheet.xyz/c/business-tech-stack 📅 Book 1 on 1 consulting with me - https://cal.com/eamonncottrell _______________________________________________ 📲 Find me https://eamonncottrell.com on LinkedIn: https://www.linkedin.com/in/eamonncottrell/ on Twitter: https://twitter.com/EamonnCottrell _______________________________________________ 📍Chapter Time Markers: 00:00:00 - setup 00:00:50 - opening power query 00:01:36 - dirty data 00:01:48 - transform - trim 00:02:01 - Group By 00:02:46 - load into excel 00:03:24 - Queries and connections #PowerQuery #ExcelTips #DataCleaning