Following is the screenshot of Sheet1:
And now put the following Formula in Cell A2 of Sheet2:
=transpose(query(transpose('Sheet1'!A:B);"select Col2,Col3,Col4,Col5 where Col1 = '" & A1 & "'"))
Now if you put 'week 1' in Cell A1, you will get the following output:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.