The FASTEST Way to Unstack Data in Power Query? 3 Methods Compared

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders-... File Reference for this video: 0261 PQ Unstack Comparison ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ In this video, we explore three different methods for unstacking a single column of data into multiple columns using Power Query. After working through step-by-step, we then reveal which has the fastest refresh. But we also identify an error, which means we may not want to use the fastest method 00:00 Introduction 00:22 Scenario & WRAPROWS 01:28 Method #1 03:56 Method #2 05:56 Method #3 08:44 Which is the fastest? 10:13 Possible errors 11:37 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel