Advanced Grouping - Power Query Challenge 18 скачать в хорошем качестве

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