Spreadsheet: 94018d1293793240-copying-data-from-a-table-to-another-one-example-fix-v2
Sheet: DATA

 |  |  |  | P1 |  |  |  |  |  |  |  |  |  |  |  |  | P2 |  |  |  |  |  |  |  |  |  |  |  |  | P3
 |  |  |  | 2005-10-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2004-11-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2006-10-11 00:00:00
 |  |  | Date |  | F | V | H |  | U |  | R |  | P |  |  | DEC |  | F | V | H |  | U |  | R |  | P |  |  | DEC |  | F | V | H |  | U |  | R |  | P |  |  | DEC
1 | VE | 6 | 2010-01-01 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
1 | SA | 7 | 2010-01-02 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
1 | DI | 1 | 2010-01-03 00:00:00 | F | 0.5 |  | 0 |  | 0 |  | 0 |  | 0.5 | WP |  | WP | H |  |  | 1 | 1 | 0 |  | 0 |  |  | H |  | H | F | 0.5 |  | 0 |  | 0 |  | 0 |  | 0.5
2 | LU | 2 | 2010-01-04 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 2 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
2 | MA | 3 | 2010-01-05 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 3 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
2 | ME | 4 | 2010-01-06 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 4 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
2 | JE | 5 | 2010-01-07 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 5 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
2 | VE | 6 | 2010-01-08 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 6 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
2 | SA | 7 | 2010-01-09 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 7 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
2 | DI | 1 | 2010-01-10 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 8 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
3 | LU | 2 | 2010-01-11 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 9 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
3 | MA | 3 | 2010-01-12 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 10 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
3 | ME | 4 | 2010-01-13 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 11 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
3 | JE | 5 | 2010-01-14 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 12 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
3 | VE | 6 | 2010-01-15 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 13 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
3 | SA | 7 | 2010-01-16 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | H |  |  | 14 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
3 | DI | 1 | 2010-01-17 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | H |  |  | 15 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | F | 1 |  | 0 |  | 0 |  | 0
4 | LU | 2 | 2010-01-18 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 16 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
4 | MA | 3 | 2010-01-19 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 17 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
4 | ME | 4 | 2010-01-20 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 18 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
4 | JE | 5 | 2010-01-21 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 19 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
4 | VE | 6 | 2010-01-22 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 20 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
4 | SA | 7 | 2010-01-23 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | H |  |  | 21 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | F | 1 |  | 0 |  | 0 |  | 0
4 | DI | 1 | 2010-01-24 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 22 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | LU | 2 | 2010-01-25 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 23 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | MA | 3 | 2010-01-26 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 24 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | ME | 4 | 2010-01-27 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 25 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | JE | 5 | 2010-01-28 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 26 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | VE | 6 | 2010-01-29 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 27 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
5 | SA | 7 | 2010-01-30 00:00:00 | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | H |  |  | 28 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | F | 1 |  | 0 |  | 0 |  | 0
5 | DI | 1 | 2010-01-31 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | H |  |  | 29 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
6 | LU | 2 | 2010-02-01 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 1 |  | P | P | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
6 | MA | 3 | 2010-02-02 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
6 | ME | 4 | 2010-02-03 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 1 | 1 | 0 |  | 0 |  |  | H |  | H | F | 0.5 |  | 0 |  | 0 |  | 0 |  | 0.5
6 | JE | 5 | 2010-02-04 00:00:00 | V |  | 1 | 0 |  | 0 |  | 0 |  |  | V |  | V | H |  |  | 2 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
6 | VE | 6 | 2010-02-05 00:00:00 | V |  |  | 0 |  | 0 |  | 0 |  |  | V1 |  | ES | H |  |  | 3 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
6 | SA | 7 | 2010-02-06 00:00:00 | V |  |  | 0 |  | 0 |  | 0 |  |  | V1 |  | V1 | H |  |  | 4 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
6 | DI | 1 | 2010-02-07 00:00:00 | V |  |  | 0 |  | 0 |  | 0 |  |  | V1 |  | V1 | H |  |  | 5 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
7 | LU | 2 | 2010-02-08 00:00:00 | V |  |  | 0 |  | 0 |  | 0 |  |  | V1 |  | V1 | H |  |  | 6 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
7 | MA | 3 | 2010-02-09 00:00:00 | P |  |  | 0 |  | 0 |  | 0 |  | 444 |  | P | XD | H |  |  | 7 | 1 | 0 |  | 0 |  |  | H |  | XD3 | F | 1 |  | 0 |  | 0 |  | 0
7 | ME | 4 | 2010-02-10 00:00:00 | R |  |  | 0 |  | 0 |  | 1 | 0.5 |  |  |  | 4 | H |  |  | 8 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
7 | JE | 5 | 2010-02-11 00:00:00 | R |  |  | 0 |  | 0 |  | 2 | 0.5 |  |  |  |  | H |  |  | 9 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
7 | VE | 6 | 2010-02-12 00:00:00 | R |  |  | 0 |  | 0 |  | 3 | 0.5 |  |  |  |  | H |  |  | 10 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
7 | SA | 7 | 2010-02-13 00:00:00 | R |  |  | 0 |  | 0 |  | 4 | 0.5 |  |  |  |  | H |  |  | 11 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
7 | DI | 1 | 2010-02-14 00:00:00 | R |  |  | 0 |  | 0 |  | 5 | 0.5 |  |  |  |  | H |  |  | 12 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
8 | LU | 2 | 2010-02-15 00:00:00 | R |  |  | 0 |  | 0 |  | 6 | 0.5 |  |  |  |  | H |  |  | 13 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
8 | MA | 3 | 2010-02-16 00:00:00 | R |  |  | 0 |  | 0 |  | 7 | 0.5 |  |  |  |  | H |  |  | 14 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
8 | ME | 4 | 2010-02-17 00:00:00 | R |  |  | 0 |  | 0 |  | 8 | 0.5 |  |  |  |  | H |  |  | 15 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | F | 1 |  | 0 |  | 0 |  | 0
8 | JE | 5 | 2010-02-18 00:00:00 | R |  |  | 0 |  | 0 |  | 9 | 0.5 |  |  |  |  | H |  |  | 16 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
8 | VE | 6 | 2010-02-19 00:00:00 | R |  |  | 0 |  | 0 |  | 10 | 0.5 |  |  |  |  | H |  |  | 17 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
8 | SA | 7 | 2010-02-20 00:00:00 | R |  |  | 0 |  | 0 |  | 11 | 0.5 |  |  |  |  | H |  |  | 18 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
8 | DI | 1 | 2010-02-21 00:00:00 | R |  |  | 0 |  | 0 |  | 12 | 0.5 |  |  |  |  | H |  |  | 19 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | LU | 2 | 2010-02-22 00:00:00 | R |  |  | 0 |  | 0 |  | 13 | 0.5 |  |  |  |  | H |  |  | 20 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | MA | 3 | 2010-02-23 00:00:00 | R |  |  | 0 |  | 0 |  | 14 | 0.5 |  |  |  |  | H |  |  | 21 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | F | 1 |  | 0 |  | 0 |  | 0
9 | ME | 4 | 2010-02-24 00:00:00 | R |  |  | 0 |  | 0 |  | 15 | 0.5 |  |  |  |  | H |  |  | 22 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | JE | 5 | 2010-02-25 00:00:00 | R |  |  | 0 |  | 0 |  | 16 | 0.5 |  |  |  |  | H |  |  | 23 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | VE | 6 | 2010-02-26 00:00:00 | R |  |  | 0 |  | 0 |  | 17 | 0.5 |  |  |  |  | H |  |  | 24 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | SA | 7 | 2010-02-27 00:00:00 | R |  |  | 0 |  | 0 |  | 18 | 0.5 |  |  |  |  | H |  |  | 25 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
9 | DI | 1 | 2010-02-28 00:00:00 | R |  |  | 0 |  | 0 |  | 19 | 0.5 |  |  |  |  | H |  |  | 26 | 0.5 | 0 |  | 0 |  |  | H1 |  | H1 | P |  |  | 0 |  | 0 |  | 0 |  | 1
10 | LU | 2 | 2010-03-01 00:00:00 | R |  |  | 0 |  | 0 |  | 20 | 0.5 |  |  |  |  | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
10 | MA | 3 | 2010-03-02 00:00:00 | R |  |  | 0 |  | 0 |  | 21 | 0.5 |  |  |  |  | F | 1 |  | 0 |  | 0 |  | 0 |  |  | W |  | W | F | 1 |  | 0 |  | 0 |  | 0
10 | ME | 4 | 2010-03-03 00:00:00 | R |  |  | 0 |  | 0 |  | 22 | 0.5 |  |  |  |  | H |  |  | 1 | 1 | 0 |  | 0 |  |  | H |  | H | F | 0.5 |  | 0 |  | 0 |  | 0 |  | 0.5
10 | JE | 5 | 2010-03-04 00:00:00 | R |  |  | 0 |  | 0 |  | 23 | 0.5 |  |  |  |  | H |  |  | 2 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
10 | VE | 6 | 2010-03-05 00:00:00 | R |  |  | 0 |  | 0 |  | 24 | 0.5 |  |  |  |  | H |  |  | 3 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
10 | SA | 7 | 2010-03-06 00:00:00 | R |  |  | 0 |  | 0 |  | 25 | 0.5 |  |  |  |  | H |  |  | 4 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
10 | DI | 1 | 2010-03-07 00:00:00 | R |  |  | 0 |  | 0 |  | 26 | 0.5 |  |  |  |  | H |  |  | 5 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
11 | LU | 2 | 2010-03-08 00:00:00 | R |  |  | 0 |  | 0 |  | 27 | 0.5 |  |  |  |  | H |  |  | 6 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
11 | MA | 3 | 2010-03-09 00:00:00 | R |  |  | 0 |  | 0 |  | 28 | 0.5 |  |  |  |  | H |  |  | 7 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
11 | ME | 4 | 2010-03-10 00:00:00 | R |  |  | 0 |  | 0 |  | 29 | 0.5 |  |  |  |  | H |  |  | 8 | 1 | 0 |  | 0 |  |  | H |  | H | F | 1 |  | 0 |  | 0 |  | 0
11 | JE | 5 | 2010-03-11 00:00:00 | R |  |  | 0 |  | 0 |  | 30 | 0.5 |  |  |  |  | H |  |  | 9 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1
11 | VE | 6 | 2010-03-12 00:00:00 | R |  |  | 0 |  | 0 |  | 31 | 0.5 |  |  |  |  | H |  |  | 10 | 1 | 0 |  | 0 |  |  | H |  | H | P |  |  | 0 |  | 0 |  | 0 |  | 1