Spreadsheet: 888143d1738587022-extract-multiple-employee-id-based-on-project-name-from-one-sheet-to-another-using-formula-sample_repivot_data
Sheet: GROUPBY

Matched to a pre-defined Project List: |  |  |  |  |  |  | [NAME] and Sort by Project-ID: |  |  |  |  |  |  | Basic Text to Columns: |  |  |  |  |  | Basic CSV Results (with [NAME]):
ID | Project | Names |  |  |  |  | ID | Project | Names |  |  |  |  | Project | Names |  |  |  |  |  | Name
 |  |  | Name-3 | Name-6 |  |  |  | Project-1 | Name-1 | Name-3 | Name-6 |  |  |  | Name-1 | Name-3 | Name-6 |  |  | Project-1 | Name-1, Name-3, Name-6
2 | Project-2 | Name-1 | [NAME] | Name-5 |  |  | 2 | Project-2 | Name-1 | [NAME] | Name-5 |  |  | Project-10 | [NAME] | Name-3 | Name-4 | Name-5 |  | Project-10 | Name-2, Name-3, Name-4, Name-5
3 | Project-3 | Name-1 | Name-3 |  |  |  | 3 | Project-3 | Name-1 | Name-3 |  |  |  | Project-11 | [NAME] | Name-5 |  |  |  | Project-11 | Name-2, Name-5
4 | Project-4 | Name-4 |  |  |  |  | 4 | Project-4 | Name-4 |  |  |  |  | Project-12 | Name-7 | Name-8 |  |  |  | Project-12 | Name-7, Name-8
5 | Project-5 | [NAME] | Name-4 | Name-5 |  |  | 5 | Project-5 | [NAME] | Name-4 | Name-5 |  |  | Project-13 | Name-8 |  |  |  |  | Project-13 | Name-8
6 | Project-6 | Name-4 | Name-6 |  |  |  | 6 | Project-6 | Name-4 | Name-6 |  |  |  | Project-2 | Name-1 | [NAME] | Name-5 |  |  | Project-2 | Name-1, Name-2, Name-5
7 | Project-7 |  |  |  |  |  | 8 | Project-8 | Name-6 |  |  |  |  | Project-3 | Name-1 | Name-3 |  |  |  | Project-3 | Name-1, Name-3
8 | Project-8 | Name-6 |  |  |  |  | 9 | Project-9 | Name-3 | Name-6 |  |  |  | Project-4 | Name-4 |  |  |  |  | Project-4 | Name-4
9 | Project-9 | Name-3 | Name-6 |  |  |  | 10 | Project-10 | [NAME] | Name-3 | Name-4 | Name-5 |  | Project-5 | [NAME] | Name-4 | Name-5 |  |  | Project-5 | Name-2, Name-4, Name-5
10 | Project-10 | [NAME] | Name-3 | Name-4 | Name-5 |  | 11 | Project-11 | [NAME] | Name-5 |  |  |  | Project-6 | Name-4 | Name-6 |  |  |  | Project-6 | Name-4, Name-6
11 | Project-11 | [NAME] | Name-5 |  |  |  | 12 | Project-12 | Name-7 | Name-8 |  |  |  | Project-8 | Name-6 |  |  |  |  | Project-8 | Name-6
12 | Project-12 | Name-7 | Name-8 |  |  |  | 13 | Project-13 | Name-8 |  |  |  |  | Project-9 | Name-3 | Name-6 |  |  |  | Project-9 | Name-3, Name-6
13 | Project-13 | Name-8
14 | Project-14
15 | Project-15
16 | Project-16
17 | Project-17
18 | Project-18
19 | Project-19
20 | Project-20
21 | Project-21
22 | Project-22
23 | Project-23
24 | Project-24
25 | Project-25
26 | Project-26
27 | Project-27
28 | Project-28
29 | Project-29
30 | [NAME]
31 | Project-31
32 | Project-32
33 | Project-33
34 | [NAME]
35 | Project-35
36 | Project-36
37 | Project-37
38 | Project-38
39 | [NAME]
40 | Project-40
41 | Project-41
42 | Project-42
43 | Project-43
44 | Project-44
45 | [NAME]
46 | Project-46
47 | Project-47
48 | Project-48
49 | Project-49
50 | Project-50
51 | Project-51
52 | Project-52
53 | Project-53
54 | Project-54
55 | Project-55
56 | Project-56
57 | Project-57
58 | Project-58
59 | Project-59
60 | Project-60
61 | Project-61
62 | Project-62
63 | Project-63
64 | Project-64
65 | Project-65
66 | Project-66
67 | Project-67
68 | Project-68
69 | Project-69
70 | [NAME]
71 | Project-71
72 | Project-72
73 | Project-73
74 | Project-74
75 | Project-75
76 | Project-76
77 | Project-77
78 | Project-78
79 | Project-79
80 | Project-80
81 | Project-81
82 | Project-82
83 | Project-83
84 | Project-84
85 | Project-85
86 | Project-86
87 | [NAME]
88 | Project-88
89 | Project-89
90 | Project-90
91 | Project-91
92 | Project-92
93 | Project-93
94 | Project-94
95 | Project-95
96 | Project-96
97 | Project-97
98 | [NAME]
99 | Project-99
100 | Project-100
101 | Project-101
102 | Project-102
103 | Project-103
104 | Project-104
105 | Project-105
106 | Project-106
107 | Project-107
108 | Project-108
109 | Project-109
110 | Project-110
111 | Project-111
112 | Project-112
113 | Project-113
114 | Project-114
115 | [NAME]
116 | Project-116
117 | [NAME]
118 | [NAME]
119 | Project-119
120 | Project-120
121 | Project-121
122 | Project-122
123 | Project-123
124 | Project-124
125 | Project-125
126 | Project-126
127 | Project-127
128 | Project-128
129 | Project-129
130 | Project-130
131 | Project-131
132 | Project-132
133 | Project-133
134 | Project-134
135 | Project-135
136 | Project-136
137 | Project-137
138 | Project-138
139 | Project-139
140 | Project-140
141 | Project-141
142 | Project-142
143 | Project-143
144 | Project-144
145 | Project-145
146 | Project-146
147 | Project-147
148 | Project-148
149 | Project-149
150 | Project-150