Spreadsheet: 262908d1378322544-need-to-duplicate-information-in-different-rows-recurringschedule-test
Sheet: -

Raw Data
Recurring Schedule Report
San Antonio
Sorted by Last Name  |  Created: 12:21 PM CDT, 09/04/2013
Name | ACD Sign In | UserName | HR System Id | Day of Week | [NAME] | Start Time | End Time | Duration | Total Hours
JONES, [NAME] | 9925 | [NAME] | 1234567 | Monday | ABC Co.. | 07:00 | 15:30 | 08:00
 |  |  |  | Tuesday | ABC Co.. | 07:00 | 15:30 | 08:00
 |  |  |  | Wednesday | ABC Co.. | 07:00 | 15:30 | 08:00
 |  |  |  | Thursday | ABC Co.. | 07:00 | 15:30 | 08:00
 |  |  |  | Friday | ABC Co.. | 07:00 | 15:30 | 08:00 | 40:00
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Tuesday | ABC Co.. | 12:00 | 20:00 | 07:30
 |  |  |  | Wednesday | ABC Co.. | 12:00 | 20:00 | 07:30
 |  |  |  | Thursday | ABC Co.. | 12:00 | 20:00 | 07:30
 |  |  |  | Friday | ABC Co.. | 12:00 | 20:00 | 07:30
 |  |  |  | Saturday | ABC Co.. | 08:00 | 16:00 | 07:30 | 37:30
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Monday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Tuesday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Wednesday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Thursday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Friday | ABC Co.. | 08:00 | 16:30 | 08:00 | 40:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Monday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Tuesday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Friday | ABC Co.. | 08:00 | 16:30 | 08:00
 |  |  |  | Saturday | ABC Co.. | 06:00 | 14:30 | 08:00
 |  |  |  | Sunday | ABC Co.. | 07:30 | 16:00 | 08:00 | 40:00
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Tuesday | DTN - Only | 12:00 | 20:00 | 07:30
 |  |  |  | Wednesday | DTN - Only | 12:00 | 20:00 | 07:30
 |  |  |  | Thursday | DTN - Only | 12:00 | 20:00 | 07:30
 |  |  |  | Friday | DTN - Only | 12:00 | 20:00 | 07:30
 |  |  |  | Saturday | DTN - Only | 08:00 | 16:00 | 07:30 | 37:30
Desired result
Recurring Schedule Report
San Antonio
Sorted by Last Name  |  Created: 12:21 PM CDT, 09/04/2013
Name | ACD Sign In | UserName | HR System Id | Day of Week | [NAME] | Start Time | End Time | Duration | Total Hours
JONES, [NAME] | 9925 | [NAME] | 1234567 | Monday | ABC Co.. | 07:00 | 15:30 | 08:00
JONES, [NAME] | 9925 | [NAME] | 1234567 | Tuesday | ABC Co.. | 07:00 | 15:30 | 08:00
JONES, [NAME] | 9925 | [NAME] | 1234567 | Wednesday | ABC Co.. | 07:00 | 15:30 | 08:00
JONES, [NAME] | 9925 | [NAME] | 1234567 | Thursday | ABC Co.. | 07:00 | 15:30 | 08:00
JONES, [NAME] | 9925 | [NAME] | 1234567 | Friday | ABC Co.. | 07:00 | 15:30 | 08:00 | 40:00
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Tuesday | ABC Co.. | 12:00 | 20:00 | 07:30
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Wednesday | ABC Co.. | 12:00 | 20:00 | 07:30
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Thursday | ABC Co.. | 12:00 | 20:00 | 07:30
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Friday | ABC Co.. | 12:00 | 20:00 | 07:30
BLACK LABEL, MABEL | 2964 | [NAME] | 7654321 | Saturday | ABC Co.. | 08:00 | 16:00 | 07:30 | 37:30
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Monday | ABC Co.. | 08:00 | 16:30 | 08:00
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Tuesday | ABC Co.. | 08:00 | 16:30 | 08:00
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Wednesday | ABC Co.. | 08:00 | 16:30 | 08:00
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Thursday | ABC Co.. | 08:00 | 16:30 | 08:00
MCGILLICUTTY, LUCILLE | 5620 | [NAME] | 3645732 | Friday | ABC Co.. | 08:00 | 16:30 | 08:00 | 40:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Monday | ABC Co.. | 08:00 | 16:30 | 08:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Tuesday | ABC Co.. | 08:00 | 16:30 | 08:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Friday | ABC Co.. | 08:00 | 16:30 | 08:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Saturday | ABC Co.. | 06:00 | 14:30 | 08:00
MERTZ, ETHEL | 3596 | EMERTZ | 8729548 | Sunday | ABC Co.. | 07:30 | 16:00 | 08:00 | 40:00
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Tuesday | DTN - Only | 12:00 | 20:00 | 07:30
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Wednesday | DTN - Only | 12:00 | 20:00 | 07:30
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Thursday | DTN - Only | 12:00 | 20:00 | 07:30
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Friday | DTN - Only | 12:00 | 20:00 | 07:30
MORRIS, PHILLIP | 3453 | PHILMOR | 6458392 | Saturday | DTN - Only | 08:00 | 16:00 | 07:30 | 37:30