If you have inconsistent or messy data watch this video to learn how to clean and structure your data by using these 8 powerful Power Query Transformations.
You can download the practice examples here: https://docs.google.com/spreadsheets/d/1V_xWoA0R8xG5a3dgjBmTHx_Geqa0O3Ah/edit?usp=sharing&ouid=108573460979392589182&rtpof=true&sd=true
00:00 Data is Messy
00:20 Split Text into Their Own Rows
03:51 Fix Inconsistent Data E.g. 1
08:36 Report with Fixed Layout E.g. 1
09:51 Report with Fixed Layout E.g. 2
10:53 Report with Fixed Layout E.g. 3
12:02 Report with Fixed Layout E.g. 4
13:04 Change Columns to Rows of Data
14:24 Fix Inconsistent Data E.g. 2
✅ Please see link to videos mentioned in this video:
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: https://youtu.be/xboyhrbo0uM
🎦 Power Query VLOOKUP - How to Perform VLOOKUP in Power Query in Excel using Merge Tables: https://youtu.be/RK8BkbjzROo
🎦 Advanced Unpivot in Power Query - Transpose Multiple Columns & Multiple Headers Without Any Formulas: https://youtu.be/4lVNS83ivsA
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:
☕https://www.buymeacoffee.com/missmicrosoft
✅ For more videos please subscribe:
🔔https://www.youtube.com/channel/UCcZhWH_xKNZFIBbBjz1VsWw?sub_confirmation=1
✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-foundations-learn-the-most-important-features-of-excel/?referralCode=AD9171333F41E4B774DA