PQ Challenge Splits and Lists

In this challenge we need to use Power Query to split data, pair lists, avoid hard coding header references and more...

00:00 Intro
00:42 The Challenge
03:18 Avoid renaming a column directly via adding a conditional column step
05:48 Avoid renaming a column directly via a fancy formula trick
09:46 Extract data from 4th character using Extract From Range
10:50 Extract data from 4th character using Split by Position
11:36 Splitting Text into Lists and Recombining using Table.FromColumns

Link to Gil's Blog Post https://datachant.com/2017/01/26/powe...

Link to Oz's video    • Power Query: Split Multiple Columns i...  


If you'd like to have a go before (or after) watching my approach then you can download the file from our blog here...
https://accessanalytic.com.au/new-yea...

Feel free to send us your approach and we'll add it to the blog page (unless you would prefer us not to).

Connect with me
https://wyn.bio.link/

Sign up for our newsletter to get advance notice of the future challenges...
https://accessanalytic.com.au/free-ex...