Thanks @Jakeu1701 Check out my other best practices videos as well. Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @rikosembiring Check out my other best practices videos as well. Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.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}))
simple to follow and understand, explained the process well, thanks!
Thanks @Jakeu1701
Check out my other best practices videos as well.
Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
Cool video... always be enthusiastic and healthy
Thanks @rikosembiring
Check out my other best practices videos as well.
Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.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}))
Sure. The purpose of using Power Query is to offload non-essential processing to the Import stage.