You can use the below SQL Query for getting the output as you want (Week 1 output format),
SELECT Region Name, NAV Today, NAV Yest, Mkt Rate
(SELECT Region Name, NAV Today, NAV Yest FROM TableName) p
(Orders FOR NAV Today, NAV Yesterday IN
(NAV Today, NAV Yest)) AS unpvt;
Same way you can use the above query and modify it to get the output for Week 2 and Week 3.