Transpose Data from Sheet1 to Sheet2

Hello:

Please refer TO ATTACHED EXCEL FILE.
(Earlier i had different requirement)

Sheet1 shows Clockin_ClockOut info for employees.

I need these data to be transpose in format shown in Sheet2.

VB macro or formula would work for me.

Please let me know if any questions.

Thank you

Riz Momin