Split column by position – Power Query

Simplify data cleanup Power Query magic. Excel and Power BI Split column by position – made easy. No trial and error, no mistakes.

Download sample file

Contents

1. Intro – 00:00
2. Base data – 00:23
3. Split column by position – 00:41
4. The problem – 01:52
5. The solution – 02:08
6. Create temporary table – 02:16
7. Split each character – 02:41
8. Snip image – 03:44
9. Check data types – 04:40
10. How to cross check – 05:08
11. Rename Columns – 05:32
12. Delete temp table – 05:44
13. Summary – 06:02

Related videos

Consolidate multiple sheets – similar or unclean data – Power Query Sections

Merged rows – Data Clean up – Excel Power Query @efficiency365

Don’t use VLOOKUP. Use Merge Table or Data Model. Power Query and Excel