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...
Merged rows - Data Clean up - Excel Power Query @efficiency365 - • Merged rows - Data Clean up - Excel P...
Don't use VLOOKUP. Use Merge Table or Data Model. Power Query and Excel. - • Don't use VLOOKUP. Use Merge Table or...
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)
On this page of the site you can watch the video online Split column by position - Power Query | @efficiency365 with a duration of hours minute second in good quality, which was uploaded by the user Efficiency 365 by Dr Nitin 17 June 2024, share the link with friends and acquaintances, this video has already been watched 769 times on youtube and it was liked by 26 viewers. Enjoy your viewing!
