Help to prepare dynamic table in excel

Hi there,
dummy.xlsx
PFA refer to sheet 1 in which i have the data and i want my data as per given in sheet 2. please help me do this.

Thanks in advance !

use ctrl+d between week intervals and then run a pivot

Thanks for the help vijay, but my requirement is i need to compare only two weeks at the time and if i change week no for current and previous it should ideally get changed automatically.