VB Code or formula to rearrange data

[rizmomin]

Hello:

Please refer to attached file.

I have data as shown in Sheet1, Column C is employee name.
The data are schedule for employee, Column D and E for MON, Column F and G for TUE, Column H & I for WED and so on until SUNDAY.
I need formula or VB approch to put the data for related employee in Sheet2 in column D,F,H,J,L,N and p for MON-SUN as shown.
I have manually done so for MON.

Let me know if you have any questions.
Thanks.

Riz