Merge and Compile Data

Hello:

Please refer to attachced sheet.

Sheet2 is the employee ClockIn-Clockout info
Each day will have 4 columns and data will start from Cell O46

I want to compile Clockin-ClockOut data in Sheet3 by merging Clockin-ClockOut field together.

As an example I have manually pasted 3 days for Employee "Rojee"

Either VB Macro or formual would work for me.

Please let me know if any questions.

Thanks in advance for your help.


Riz