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
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 s...
Merged rows - Data Clean up - Excel Power Query @efficiency365 - • Merged rows - Data Cle...
Don't use VLOOKUP. Use Merge Table or Data Model. Power Query and Excel. - • Don't use VLOOKUP. Use...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)
Пікірлер: 4
Cool video... always be enthusiastic and healthy
@efficiency365
29 күн бұрын
Thanks @rikosembiring Check out my other best practices videos as well. Task Management Best Practices - kzread.info/dash/bejne/dn6X2rKtpZDYk8o.html Efficient Tasks Management using the New Planner 2024 - kzread.info/dash/bejne/nZus09x9mdXdYdI.html Microsoft Teams Meetings - 16 Best Practices - kzread.info/dash/bejne/nmd22NNmeZPOqZc.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.
Thank you. These are so useful power query tips, assuming data are stored in range A1:A10 same result can be achieved using LET and MID functions written in array-based syntax as of the following: =LET(chr,A1:A10,MID(chr,{1,2,6,9,13,15},{1,4,3,4,2,2}))
@efficiency365
24 күн бұрын
Sure. The purpose of using Power Query is to offload non-essential processing to the Import stage.