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-signup/
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: https://twitter.com/exceloffthegrid

#MsExcel

Видео The FASTEST Way to Unstack Data in Power Query? 3 Methods Compared канала Excel Off The Grid