Create Fixed-Length IDs - Power Query Challenge 31
Create Fixed-Length IDs - Power Query Challenge 31
In this Power Query tutorial, learn how to ensure that each ID in your data has exactly six characters by inserting zeros between the text and numbers. We will walk you through splitting the ID into text and number parts, calculating the correct number of zeros to add, and merging everything back together. We’ll also cover different methods for merging columns in Power Query and explain how to reorder columns in the formula bar. This is a practical tutorial designed to help you manage your IDs with fixed lengths. Whether you're new to Power Query or looking to refine your skills, this video will guide you through the process step by step. Stay tuned for more helpful Power Query tips!
Timestamps:
00:00 Introduction to the Challenge
00:04 Loading the Table into Power Query
00:12 Splitting the ID Column by Transition
00:25 Creating Custom Column for Padding
00:42 Adding Zeros for 6 Character ID
00:58 Merging Columns to Finalize IDs
01:20 Two Methods for Merging Columns
01:36 Final Adjustments and Completion
🔔 Subscribe for more tutorials: / @howtolearnexcel
Links:
Challenge Author: Omid Motamedisedeh
LinkedIn: / omidmot
Youtube: / @omidbi
Website: https://www.omidbi.com/
Power Query Challenge: https://www.linkedin.com/posts/omid-m...
Download Workbook:
https://lnkd.in/gdMgg2Sv
'Power Query Challenges' Playlist: • Power Query: Challenges
#PowerQuery #PowerQueryChallenge #ExcelChallenge #HowToLearnExcel