Spreadsheet: 63666d1264549544-make-a-list-without-blank-cells-example
Sheet: Sheet2

 |  | 2010-01-24 00:00:00 |  |  |  | 2010-01-25 00:00:00 |  |  |  | 2010-01-26 00:00:00 |  |  |  | 2010-01-27 00:00:00 |  |  |  | 2010-01-28 00:00:00 |  |  |  | 2010-01-29 00:00:00 |  |  |  | 2010-01-30 00:00:00
Name | Team | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur | Start Time | Stop Time | Shif_Dur | OT Dur
A | 1 | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00 | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00
B | 1 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
C | 1 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
D | 1 | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
E | 2 | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
F | 2 | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | VAC | VAC | VAC | VAC | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
G | 2 | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | 17:00:00 | 21:00:00 | 04:00:00 | 1900-01-01 00:00:00 | 17:00:00 | 21:00:00 | 04:00:00 | 1900-01-01 00:00:00 | 17:00:00 | 21:00:00 | 04:00:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00
H | 2 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
I | 3 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
J | 3 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00
K | 3 | WO | WO | WO | WO | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00
L | 3 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00
M | 4 | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00
N | 4 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 10:30:00 | 19:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 10:30:00 | 19:00:00 | 08:30:00 | 1900-01-01 00:00:00
O | 4 | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
P | 4 | WO | WO | WO | WO | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:00:00 | 20:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
Q | 5 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00
R | 5 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
S | 5 | WO | WO | WO | WO | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00
T | 5 | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00 | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 21:00:00 | 12:00:00 | 1900-01-01 00:00:00
U | 6 | WO | WO | WO | WO | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | 12:30:00 | 21:00:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
V | 6 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00
W | 6 | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 11:00:00 | 19:30:00 | 08:30:00 | 1900-01-01 00:00:00
X | 6 | WO | WO | WO | WO | WO | WO | WO | WO | 09:00:00 | 14:00:00 | 05:00:00 | 1900-01-01 00:00:00 | 09:00:00 | 14:00:00 | 05:00:00 | 1900-01-01 00:00:00 | 09:00:00 | 14:00:00 | 05:00:00 | 1900-01-01 00:00:00 | 09:00:00 | 14:00:00 | 05:00:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
Y | 7 | WO | WO | WO | WO | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00 | 08:30:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO
X | 7 | WO | WO | WO | WO | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | WO | WO | WO | WO | WO | WO | WO | WO | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 21:00:00 | 11:00:00 | 1900-01-01 00:00:00