VB Code to transpose data

Hello:

Please refer to attached file.

I have employee Clock IN - Clock Out as shown in Column A thru C.
An employee can have more then 1 Clock In Clock Out as shown for Employee Name Karmen and Haley.

As shown, each employee is separated by "----------------------" and it ends with "REPORT END"

I would like a VB Code to transpose the data as shown in Column G thru H

Let me Know if you have any questions.
Thanks.

Riz

Hi bsalv:

Thanks a lot, this will work great for me.

Riz