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/power-bi-pitfall-6/ Link to Oz's video https://www.youtube.com/watch?v=JMOnr3DOqyk 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-year-power-query-challenge/ 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-excel-stuff/newsletter/