Google sheets: Transpose function not working/populating data on other cell

Hi guys,

I have a sheet (I have copied a master sheet, the neweer sheet has additional data)

Ples see sheet here:

https://docs.google.com/spreadsheets...it?usp=sharing

If you refer to the tab: Copy of leaderboard ver3, I am unavble to replace the same result as the tab: Leaderboard v3

On copy of leaderboard ver3 tab, the main issues seem I have is why cell b4 is not pouplating leadebroard data? I have a transpose function this tab, cell K2 which is not displaying the data the same as leaderboard v3 tab.

Please help, any help appreciated.

Thank you

R.