Split a row into two for attendance set

I'm redesigning an attendance system used in my company. Originally, an attendance sheet was rendered on a grid that was getting week-by-week data pivoted. I've opted for a *scheduler* control by DevExpress. A sign-in and a sign-out are to be represented as two 'appointments' now. The scheduler requires a very specific data source for appointments. Here is my attendance table: The DutyIn_Manual is what the employee reports and the DutyIn is the actual time captured. DutyIn_Manual is to be shown on the Scheduler. Similarly, DutyOut_Manual goes into view. Now, I need to split one row into two: One for Duty In and one for Duty Out.