Pivot table in desktop query

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?