Скачать или смотреть Split column by position - Power Query | @efficiency365

Simplify data cleanup - #powerquery magic. #excel and #powerbi
Split column by position - made easy.
No trial and error, no mistakes.

Download sample file and try it yourself
https://efficiency365.com/wp-content/...

Contents 📚
00:00 - Intro
00:23 - Base data
00:41 - Split column by position
01:52 - The problem
02:08 - The solution
02:16 - Create temporary table
02:41 - Split each character
03:44 - Snip image
04:40 - Check data types
05:08 - How to cross check
05:32 - Rename Columns
05:44 - Delete temp table
06:02 - Summary


Related videos 📺
Consolidate multiple sheets - similar or unclean data - Power Query Sections -    • Consolidate multiple sheets - similar or u...  
Merged rows - Data Clean up - Excel Power Query @efficiency365 -    • Merged rows - Data Clean up - Excel Power ...  
Don't use VLOOKUP. Use Merge Table or Data Model. Power Query and Excel. -    • Don't use VLOOKUP. Use Merge Table or Data...  



Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)