Nov 26, 2022 12:00 AM

Convert Range of Values to a List - Power Query Challenge Nov 2022

External YouTube Channel

Power Query Challenge Tickets to Rows

In this Video

00:00 Intro

00:40 Recapping the Challenge

01:54 My initial solution

04:33 The Simple Curly Bracket Approach

05:27 The List.Numbers technique

06:16 The super clever Erik Svensen technique

Open the WebSite

https://accessanalytic.com.au/power-query-challenge-ticket-list/

Download the File

https://aasolutions.sharepoint.com/sites/PubliclyAvailableContent/Public%20Files/Forms/AllItems.aspx?id=%2Fsites%2FPubliclyAvailableContent%2FPublic%20Files%2FYouTube%20Content%2F2022%2011%20Power%20Query%20Challenge%20Tickets%20to%20Rows&p=true&ga=1