How to Merge multiple duplicate rows into columns

Hi there this is a repost of my problem last night since my first post was wrongly done... anyhow here's my problem:

i have this data that have lots of duplicate rows wherein they are the date a certain employee have had his time punch what i want to accomplish is that each date would be having only one row of 2 punch_in and 2 punch out.

here's my workbook: for testing.xlsm

simply put i want my the data in my rawdata sheet to appear like the one i have in sheet1

also i found a working code here though it yields an almost similar result though its not the one that i needed

here's the code:

Please Login or Register  to view this content.

thank you in advance for your help

That seems a little complex for something that simple worksheet formulas can accomplish. Delete your sheet1 so your RawData is the only sheet, then try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please post your question in a new thread of its own. Please read the Forum Rules we all abide (link above in the menu bar).

Thanks.