Spreadsheet: 766496d1643907110-extract-unique-values-from-one-table-to-another-table-sample
Sheet: Table 1

Serial # | Project Name | Type | Department | Date | Person | Amount | Daily Work | Current Project Workload by Month | Per Month Avail. | Hours | HC
2 | Project A | Aero | Purch | January | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
3 | Project A | Aero | Purch | February | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
4 | Project A | Aero | Purch | March | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
5 | Project A | Aero | Purch | April | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
6 | Project A | Aero | Purch | May | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
7 | Project A | Aero | Purch | June | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
8 | Project A | Aero | Purch | July | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
9 | Project A | Aero | Purch | August | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
10 | Project A | Aero | Purch | September | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
11 | Project A | Aero | Purch | October | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
12 | Project A | Aero | Purch | November | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
13 | Project A | Aero | Purch | December | [NAME] | 0.01 | 0.85 | 0.11 | 0.04000000000000004 | 1.6 | 0.01
14 | Project B | [NAME] | Finance | January | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
15 | Project B | [NAME] | Finance | February | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
16 | Project B | [NAME] | Finance | March | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
17 | Project B | [NAME] | Finance | April | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
18 | Project B | [NAME] | Finance | May | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
19 | Project B | [NAME] | Finance | June | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
20 | Project B | [NAME] | Finance | July | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
21 | Project B | [NAME] | Finance | August | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
22 | Project B | [NAME] | Finance | September | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
23 | Project B | [NAME] | Finance | October | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
24 | Project B | [NAME] | Finance | November | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
25 | Project B | [NAME] | Finance | December | [NAME] | 0.02 | 0.9 | 0.07 | 0.03000000000000003 | 3.2 | 0.02
26 | Project B | [NAME] | Finance | January | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
27 | Project B | [NAME] | Finance | February | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
28 | Project B | [NAME] | Finance | March | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
29 | Project B | [NAME] | Finance | April | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
30 | Project B | [NAME] | Finance | May | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
31 | Project B | [NAME] | Finance | June | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
32 | Project B | [NAME] | Finance | July | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
33 | Project B | [NAME] | Finance | August | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
34 | Project B | [NAME] | Finance | September | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
35 | Project B | [NAME] | Finance | October | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
36 | Project B | [NAME] | Finance | November | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
37 | Project B | [NAME] | Finance | December | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
38 | Project B | [NAME] | Finance | January | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
39 | Project B | [NAME] | Finance | February | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
40 | Project B | [NAME] | Finance | March | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
41 | Project B | [NAME] | Finance | April | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
42 | Project B | [NAME] | Finance | May | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
43 | Project B | [NAME] | Finance | June | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
44 | Project B | [NAME] | Finance | July | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
45 | Project B | [NAME] | Finance | August | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
46 | Project B | [NAME] | Finance | September | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
47 | Project B | [NAME] | Finance | October | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
48 | Project B | [NAME] | Finance | November | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
49 | Project B | [NAME] | Finance | December | [NAME] | 0.02 | 0.9 | 0.02 | 0.07999999999999996 | 3.2 | 0.02
50 | Project B | [NAME] | Proc | January | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
51 | Project B | [NAME] | Proc | February | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
52 | Project B | [NAME] | Proc | March | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
53 | Project B | [NAME] | Proc | April | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
54 | Project B | [NAME] | Proc | May | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
55 | Project B | [NAME] | Proc | June | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
56 | Project B | [NAME] | Proc | July | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
57 | Project B | [NAME] | Proc | August | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
58 | Project B | [NAME] | Proc | September | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
59 | Project B | [NAME] | Proc | October | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
60 | Project B | [NAME] | Proc | November | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
61 | Project B | [NAME] | Proc | December | [NAME] | 0 | 0.99 | 0 | 0.01000000000000001 | 0 | 0
62 | Project C | MA Ind | WH & Log. | January | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
63 | Project C | MA Ind | WH & Log. | February | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
64 | Project C | MA Ind | WH & Log. | March | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
65 | Project C | MA Ind | WH & Log. | April | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
66 | Project C | MA Ind | WH & Log. | May | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
67 | Project C | MA Ind | WH & Log. | June | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
68 | Project C | MA Ind | WH & Log. | July | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
69 | Project C | MA Ind | WH & Log. | August | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
70 | Project C | MA Ind | WH & Log. | September | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
71 | Project C | MA Ind | WH & Log. | October | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
72 | Project C | MA Ind | WH & Log. | November | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
73 | Project C | MA Ind | WH & Log. | December | [NAME] | 0.02 | 0.99 | 0.02 | -0.01000000000000001 | 3.2 | 0.02
74 | Project C | MA Ind | Purch | January | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
75 | Project C | MA Ind | Purch | February | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
76 | Project C | MA Ind | Purch | March | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
77 | Project C | MA Ind | Purch | April | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
78 | Project C | MA Ind | Purch | May | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
79 | Project C | MA Ind | Purch | June | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
80 | Project C | MA Ind | Purch | July | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
81 | Project C | MA Ind | Purch | August | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
82 | Project C | MA Ind | Purch | September | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
83 | Project C | MA Ind | Purch | October | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
84 | Project C | MA Ind | Purch | November | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
85 | Project C | MA Ind | Purch | December | [NAME] | 0.02 | 0.85 | 0.11 | 0.04000000000000004 | 3.2 | 0.02
86 | Project C | MA Ind | Proc | January | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
87 | Project C | MA Ind | Proc | February | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
88 | Project C | MA Ind | Proc | March | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
89 | Project C | MA Ind | Proc | April | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
90 | Project C | MA Ind | Proc | May | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
91 | Project C | MA Ind | Proc | June | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
92 | Project C | MA Ind | Proc | July | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
93 | Project C | MA Ind | Proc | August | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
94 | Project C | MA Ind | Proc | September | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
95 | Project C | MA Ind | Proc | October | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
96 | Project C | MA Ind | Proc | November | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
97 | Project C | MA Ind | Proc | December | [NAME] | 0 | 0.99 | 0.1 | -0.09000000000000008 | 0 | 0
98 | Project C | MA Ind | Purch | January | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
99 | Project C | MA Ind | Purch | February | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
100 | Project C | MA Ind | Purch | March | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
101 | Project C | MA Ind | Purch | April | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
102 | Project C | MA Ind | Purch | May | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
103 | Project C | MA Ind | Purch | June | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
104 | Project C | MA Ind | Purch | July | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
105 | Project C | MA Ind | Purch | August | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
106 | Project C | MA Ind | Purch | September | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
107 | Project C | MA Ind | Purch | October | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
108 | Project C | MA Ind | Purch | November | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02
109 | Project C | MA Ind | Purch | December | [NAME] | 0.02 | 0.85 | 0.02 | 0.13 | 3.2 | 0.02