Pivot table in desktop query

[andyor]

I have the following table structure:

My columns are SignUps, VerifiedReg, FTDs, FTWs, FTDConv%, Actives, ActiveFunders, DepositCount, DepositAmount, BetCount, CashTurnover, CashWagered, GGR, Hold%, FreeBetPayout, NGR, FreeBetStake, FreeBetStakeIssued, FreeBetStakeExpired, FreeBetActives, AvgTurnoverActives, AvgDepositAmt, AvgBetAmt, AvgFTDAmt, Avg1stBetAmt, FTWTurnover

And I want to pivot WeekNumber so that these values become all the column headers left to right. 

I've drawn this up in excel of how it might look, with dummy values. 

I've seen other posts where there are huge LET SOURCE = statements (that I would have no idea how to implement myself unfortunately). 

Is there an easier way to do this? Or can anyone help with the LET SOURCE = solution?

[andyor]

Amazing thanks! Just 1 button click and I've spent a full day on this beforehand!

[miTutorials · Accepted solution]

Watch this tutorial from 2:55

Create Table similar to Pivot in PowerBI | switch Column headers to rows | MI Tutorials - YouTube