Advanced Grouping - Power Query Challenge 18

Описание: Advanced Grouping - Power Query Challenge 18

In this tutorial, we'll dive into an exciting Power Query challenge where we'll sort cookies into two groups: those with duplicate prices and those with unique ones.
We'll walk you through each step, using the 'Group By' function and some clever transformations to achieve our goal. Whether you're a Power Query newbie or looking to sharpen your skills, this video has something for you.
Join us as we uncover new tricks and techniques to handle your data like a pro. Don't forget to share your favorite cookie flavor in the comments!


🔔 Subscribe for more tutorials:    / @howtolearnexcel  

Timestamps:
00:00 - Introduction to the Challenge
00:20 - Grouping Data by Price Using 'Group By' Function
00:34 - Transforming Data with 'All Rows' Option
00:47 - Cleaning Up Unneeded Type Information
01:02 - Handling Nested Tables for Products
01:20 - Creating a Duplicate Column Based on Row Count
01:45 - Setting Up a Condition for Duplicate Prices
02:01 - Creating a Unique Column for Single-Row Products
02:24 - Extracting and Combining Duplicate Cookies List
02:53 - Extracting and Combining Unique Cookies List
03:08 - Combining Lists into a Final Table
03:20 - Renaming Columns for Clarity
03:32 - Conclusion and Call to Action

Links:
CHALLENGE AUTHOR: Crispo Mwangi
LinkedIn Profile:   / crispo-mwangi-6ab49453  
Power Query Challenge: https://www.linkedin.com/posts/crispo...
Download Workbook: https://crispomwangi-my.sharepoint.co...

'Power Query Challenges' Playlist:    • Power Query: Challenges  

#PowerQuery #PowerQueryChallenge #ExcelChallenge #HowToLearnExcel