I'm working with a dataset that is categorizing multiple variables from a 0-1 basis, thus assigning them as 1-5 (out of 13), and am trying to concatenate these without duplicates to see which are applicable per record id. I am driving myself mad trying to figure this out and am hoping that a formula would work vs. code for the basic need. Or if there is a better way of combining/assessing? Please to help! It won't let me upload a file, so I'm working on that, but can send if you would like. Thanks so much!
This is horrendous, sorry!
ADMINISTRATION
14/7 14.1 Please specify:
ID G_CARE_STUDENT1 G_CARE_T_STAFF2 G_CARE_CUST_STAFF2 G_CARE_OTHER_STAFF2 G_CARE_GC4 G_CARE_PTA_VOL5 G_CARE_PTA_VOL5 G_CARE_P_VOL5 G_CARE_GCOMM4 G_CARE_AFTSCH1 G_CARE_PARTNER_ORG3 G_CARE_COMM_VOL5 G_CARE_NPR_ORG3 G_CARE_FREQ
1 2 2 2 4 5 5 5 4 1 3 5 3 108,104,18,41,24,27,28,56,63,47,20,41,24, CONCATENATE formaula for sums N4
1=CLASSES carried through for represented values in each column, but has duplicates -how do I get have a set from 1-5? represented per record Id#?
NOTE: #4 INCLUDES VOL GC 2=STAFF/DISTRICT
3=OUTSIDE ORGS (SPROUTS, 4H, UNITED WAY)
4=COORDINATOR/COMITTEE
108 104 18 41 24 27 28 56 63 47 20 41 24 5=VOLUNTEER
8 1 2 0 0 0 0 0 0 0 0 0 0 0 1,2,0,0,0,0,0,0,0,0,0,0,0,
11 1 2 0 0 0 0 0 0 0 1 0 0 0 1,2,0,0,0,0,0,0,0,1,0,0,0,
12 1 2 0 0 0 0 0 5 0 0 3 5 0 1,2,0,0,0,0,0,5,0,0,3,5,0,
13 1 2 0 0 0 0 0 0 0 0 3 5 0 1,2,0,0,0,0,0,0,0,0,3,5,0,
28 0 0 0 0 0 0 0 0 0 4 0 0 0 0,0,0,0,0,0,0,0,0,4,0,0,0,
29 0 0 2 0 0 0 0 0 0 0 0 0 0 0,0,2,0,0,0,0,0,0,0,0,0,0,
30 1 2 0 0 0 0 0 0 4 0 0 0 0 1,2,0,0,0,0,0,0,4,0,0,0,0,
36 0 0 0 0 0 0 0 0 0 0 0 5 0 0,0,0,0,0,0,0,0,0,0,0,5,0,
42 0 0 0 0 0 0 0 0 0 0 0 0 0 0,0,0,0,0,0,0,0,0,0,0,0,0,
44 0 0 0 0 0 0 0 0 4 0 0 0 0 0,0,0,0,0,0,0,0,4,0,0,0,0,
45 1 2 0 0 0 0 0 5 0 0 0 5 0 1,2,0,0,0,0,0,5,0,0,0,5,0,
46 1 0 0 0 0 5 5 0 0 0 0 0 0 1,0,0,0,0,5,5,0,0,0,0,0,0,
47 0 0 0 0 0 0 0 5 0 0 0 0 0 0,0,0,0,0,0,0,5,0,0,0,0,0,
74 1 2 0 0 0 0 0 0 0 0 0 0 0 1,2,0,0,0,0,0,0,0,0,0,0,0,
79 1 0 0 0 0 0 0 0 0 0 0 0 0 1,0,0,0,0,0,0,0,0,0,0,0,0,
90 0 2 0 0 0 0 0 0 4 0 0 0 0 0,2,0,0,0,0,0,0,4,0,0,0,0,
92 1 2 0 0 0 0 0 0 0 0 0 5 0 1,2,0,0,0,0,0,0,0,0,0,5,0,
102 0 2 2 0 0 0 0 0 0 0 0 5 0 0,2,2,0,0,0,0,0,0,0,0,5,0,
108 1 2 0 0 0 0 0 5 0 0 0 0 0 1,2,0,0,0,0,0,5,0,0,0,0,0,
135 0 0 0 0 0 0 0 0 4 1 0 0 0 0,0,0,0,0,0,0,0,4,1,0,0,0,
137 1 2 0 0 0 0 0 0 4 0 0 5 0 1,2,0,0,0,0,0,0,4,0,0,5,0,
158 1 0 0 0 0 0 0 0 0 1 0 0 0 1,0,0,0,0,0,0,0,0,1,0,0,0,
177 1 2 0 2 0 0 0 0 0 0 0 0 0 1,2,0,2,0,0,0,0,0,0,0,0,0,
189 1 2 0 0 4 0 0 0 4 0 0 0 0 1,2,0,0,4,0,0,0,4,0,0,0,0,
190 1 2 0 0 0 0 0 5 4 1 0 0 0 1,2,0,0,0,0,0,5,4,1,0,0,0,
215 1 2 0 2 4 0 0 0 0 0 0 0 0 1,2,0,2,4,0,0,0,0,0,0,0,0,
229 0 2 2 2 0 0 0 0 0 0 0 0 0 0,2,2,2,0,0,0,0,0,0,0,0,0,
230 0 2 0 0 0 0 0 0 0 0 0 0 0 0,2,0,0,0,0,0,0,0,0,0,0,0,
238 1 2 0 0 0 5 5 0 0 0 0 5 0 1,2,0,0,0,5,5,0,0,0,0,5,0,
254 1 2 0 2 0 0 0 5 4 1 0 5 0 1,2,0,2,0,0,0,5,4,1,0,5,0,
258 1 2 0 0 0 0 0 5 4 0 0 0 0 1,2,0,0,0,0,0,5,4,0,0,0,0,
259 1 2 0 0 0 0 0 5 4 0 0 0 3 1,2,0,0,0,0,0,5,4,0,0,0,3,
286 1 2 0 2 0 0 0 5 0 0 0 0 0 1,2,0,2,0,0,0,5,0,0,0,0,0,
291 0 0 0 0 0 0 0 0 0 0 0 0 3 0,0,0,0,0,0,0,0,0,0,0,0,3,
292 1 0 0 2 0 0 0 0 0 1 0 0 0 1,0,0,2,0,0,0,0,0,1,0,0,0,
293 0 0 0 0 0 0 0 0 0 1 0 0 0 0,0,0,0,0,0,0,0,0,1,0,0,0,
309 1 2 0 2 0 0 0 5 4 0 0 0 0 1,2,0,2,0,0,0,5,4,0,0,0,0,
310 1 2 0 0 0 5 5 5 4 0 0 0 0 1,2,0,0,0,5,5,5,4,0,0,0,0,
363 1 0 0 0 0 0 0 5 4 0 0 0 0 1,0,0,0,0,0,0,5,4,0,0,0,0,
369 1 2 0 0 0 0 0 0 0 1 0 5 3 1,2,0,0,0,0,0,0,0,1,0,5,3,
380 1 2 2 0 0 0 0 5 4 1 0 5 0 1,2,2,0,0,0,0,5,4,1,0,5,0,
383 1 2 0 0 0 5 5 5 0 0 0 0 0 1,2,0,0,0,5,5,5,0,0,0,0,0,
389 1 2 0 0 0 0 0 0 0 0 0 5 3 1,2,0,0,0,0,0,0,0,0,0,5,3,
390 1 2 0 0 0 5 5 0 0 0 0 0 0 1,2,0,0,0,5,5,0,0,0,0,0,0,
405 0 0 0 2 0 0 0 0 4 0 0 0 3 0,0,0,2,0,0,0,0,4,0,0,0,3,
415 0 0 0 0 0 0 0 5 4 0 0 0 0 0,0,0,0,0,0,0,5,4,0,0,0,0,
423 0 2 0 2 0 0 0 0 0 0 0 0 0 0,2,0,2,0,0,0,0,0,0,0,0,0,
436 1 2 0 2 0 0 0 0 0 1 0 0 0 1,2,0,2,0,0,0,0,0,1,0,0,0,
437 0 0 0 2 0 0 0 0 0 1 0 0 3 0,0,0,2,0,0,0,0,0,1,0,0,3,
447 1 2 0 0 4 0 0 0 0 1 0 0 0 1,2,0,0,4,0,0,0,0,1,0,0,0,
449 0 2 0 0 4 0 0 0 0 1 0 0 0 0,2,0,0,4,0,0,0,0,1,0,0,0,
459 1 2 0 0 0 0 0 0 4 1 0 0 0 1,2,0,0,0,0,0,0,4,1,0,0,0,
493 1 2 0 0 0 0 0 0 4 0 3 0 0 1,2,0,0,0,0,0,0,4,0,3,0,0,
495 1 2 0 0 0 0 0 5 0 0 3 0 0 1,2,0,0,0,0,0,5,0,0,3,0,0,
513 1 2 0 2 0 0 0 5 0 0 0 5 0 1,2,0,2,0,0,0,5,0,0,0,5,0,
517 1 2 2 2 0 5 5 5 4 0 0 0 0 1,2,2,2,0,5,5,5,4,0,0,0,0,
523 1 2 0 0 0 0 0 0 0 1 3 0 3 1,2,0,0,0,0,0,0,0,1,3,0,3,
528 1 2 2 0 0 0 0 0 0 0 0 5 0 1,2,2,0,0,0,0,0,0,0,0,5,0,
540 1 2 0 2 4 5 5 5 4 0 0 5 3 1,2,0,2,4,5,5,5,4,0,0,5,3,
545 1 2 2 2 0 0 0 5 4 1 3 5 0 1,2,2,2,0,0,0,5,4,1,3,5,0,
580 1 2 2 0 0 0 0 0 0 0 0 0 0 1,2,2,0,0,0,0,0,0,0,0,0,0,
583 1 2 2 2 0 0 0 5 4 1 0 0 0 1,2,2,2,0,0,0,5,4,1,0,0,0,
598 1 0 0 0 0 5 5 5 4 0 0 0 0 1,0,0,0,0,5,5,5,4,0,0,0,0,
624 1 2 0 0 0 5 5 5 4 1 0 0 0 1,2,0,0,0,5,5,5,4,1,0,0,0,
627 1 2 0 2 0 0 0 0 4 0 0 0 0 1,2,0,2,0,0,0,0,4,0,0,0,0,
631 1 0 0 0 0 0 0 0 4 1 0 0 0 1,0,0,0,0,0,0,0,4,1,0,0,0,
643 0 2 0 0 4 0 0 0 4 0 0 0 0 0,2,0,0,4,0,0,0,4,0,0,0,0,
665 0 0 0 0 4 0 0 0 0 0 0 0 0 0,0,0,0,4,0,0,0,0,0,0,0,0,
671 1 2 0 0 4 0 0 5 4 0 0 0 0 1,2,0,0,4,0,0,5,4,0,0,0,0,
677 0 2 0 0 0 0 0 5 0 0 0 0 0 0,2,0,0,0,0,0,5,0,0,0,0,0,
684 1 2 0 0 0 0 0 0 0 0 3 0 0 1,2,0,0,0,0,0,0,0,0,3,0,0,
694 1 2 2 2 0 0 0 0 0 1 0 0 0 1,2,2,2,0,0,0,0,0,1,0,0,0,
707 1 2 0 0 4 0 0 0 0 1 0 5 0 1,2,0,0,4,0,0,0,0,1,0,5,0,
710 1 2 0 2 0 0 0 0 4 0 0 5 0 1,2,0,2,0,0,0,0,4,0,0,5,0,
727 1 2 0 2 0 5 5 5 4 0 0 0 0 1,2,0,2,0,5,5,5,4,0,0,0,0,
739 0 0 0 2 0 0 0 0 0 1 0 0 0 0,0,0,2,0,0,0,0,0,1,0,0,0,
742 1 2 0 0 4 0 0 5 0 0 0 0 0 1,2,0,0,4,0,0,5,0,0,0,0,0,
743 1 0 0 0 4 0 0 0 0 1 0 0 0 1,0,0,0,4,0,0,0,0,1,0,0,0,
746 1 0 0 0 0 0 0 0 4 0 0 0 0 1,0,0,0,0,0,0,0,4,0,0,0,0,
747 0 0 0 0 0 0 0 5 4 1 0 5 0 0,0,0,0,0,0,0,5,4,1,0,5,0,
210 1 2 2 0 0 0 0 0 0 0 3 5 0 1,2,2,0,0,0,0,0,0,0,3,5,0,
441 1 0 0 0 0 0 0 0 0 0 0 0 3 1,0,0,0,0,0,0,0,0,0,0,0,3,
392 1 2 2 2 0 0 0 0 4 1 0 0 0 1,2,2,2,0,0,0,0,4,1,0,0,0,
320 0 0 0 2 0 0 0 0 0 0 0 0 0 0,0,0,2,0,0,0,0,0,0,0,0,0,
322 0 2 0 0 0 0 0 0 0 1 0 0 0 0,2,0,0,0,0,0,0,0,1,0,0,0,
327 1 2 2 2 0 5 5 0 0 0 0 0 0 1,2,2,2,0,5,5,0,0,0,0,0,0,
332 1 2 2 2 0 0 0 0 0 0 0 0 0 1,2,2,2,0,0,0,0,0,0,0,0,0,
492 1 2 0 0 4 0 0 0 0 0 0 0 0 1,2,0,0,4,0,0,0,0,0,0,0,0,
500 1 2 0 2 0 0 0 5 4 0 0 5 0 1,2,0,2,0,0,0,5,4,0,0,5,0,
502 0 2 0 2 0 0 0 5 0 0 0 0 0 0,2,0,2,0,0,0,5,0,0,0,0,0,
503 0 2 0 0 0 5 5 0 0 0 0 0 0 0,2,0,0,0,5,5,0,0,0,0,0,0,
520 1 0 0 0 0 0 0 5 4 0 0 5 0 1,0,0,0,0,0,0,5,4,0,0,5,0,
526 0 2 2 0 0 0 0 0 4 1 3 0 3 0,2,2,0,0,0,0,0,4,1,3,0,3,
527 1 2 0 0 0 0 0 0 0 0 3 0 3 1,2,0,0,0,0,0,0,0,0,3,0,3,
538 1 2 0 0 0 0 0 0 4 0 3 0 3 1,2,0,0,0,0,0,0,4,0,3,0,3,
549 1 2 0 0 0 0 0 5 4 0 0 5 0 1,2,0,0,0,0,0,5,4,0,0,5,0,
558 1 2 0 0 4 0 0 5 4 0 0 5 0 1,2,0,0,4,0,0,5,4,0,0,5,0,
576 1 2 0 0 4 0 0 5 0 1 0 0 0 1,2,0,0,4,0,0,5,0,1,0,0,0,
628 1 2 0 0 0 0 0 5 0 1 0 0 0 1,2,0,0,0,0,0,5,0,1,0,0,0,
709 1 2 0 2 0 0 0 0 4 1 0 0 0 1,2,0,2,0,0,0,0,4,1,0,0,0,
731 0 0 0 0 0 5 5 0 0 0 0 0 0 0,0,0,0,0,5,5,0,0,0,0,0,0,
278 1 2 0 0 0 0 0 0 0 1 0 0 3 1,2,0,0,0,0,0,0,0,1,0,0,3,
282 1 2 0 2 0 0 0 5 4 0 3 0 0 1,2,0,2,0,0,0,5,4,0,3,0,0,
232 1 2 0 0 0 0 0 0 0 0 0 0 3 1,2,0,0,0,0,0,0,0,0,0,0,3,
233 1 2 0 0 0 0 0 5 0 0 0 5 3 1,2,0,0,0,0,0,5,0,0,0,5,3,
240 0 0 0 0 0 0 0 0 0 0 3 0 0 0,0,0,0,0,0,0,0,0,0,3,0,0,
241 0 0 0 0 0 0 0 0 0 0 3 0 3 0,0,0,0,0,0,0,0,0,0,3,0,3,
481 1 0 0 0 0 0 0 0 4 0 0 0 3 1,0,0,0,0,0,0,0,4,0,0,0,3,
255 1 2 0 2 0 5 5 5 4 1 3 5 0 1,2,0,2,0,5,5,5,4,1,3,5,0,
209 1 2 0 2 0 0 0 0 0 0 0 5 0 1,2,0,2,0,0,0,0,0,0,0,5,0,
728 1 0 0 0 0 5 5 0 4 0 0 0 0 1,0,0,0,0,5,5,0,4,0,0,0,0,
410 0 2 0 0 0 0 0 5 4 1 3 5 0 0,2,0,0,0,0,0,5,4,1,3,5,0,
347 1 0 0 0 0 0 0 0 4 1 0 5 0 1,0,0,0,0,0,0,0,4,1,0,5,0,
636 1 2 0 2 0 0 0 0 4 0 3 0 0 1,2,0,2,0,0,0,0,4,0,3,0,0,
732 0 0 0 0 0 5 5 0 4 0 0 0 0 0,0,0,0,0,5,5,0,4,0,0,0,0,
355 1 2 0 2 4 5 5 5 4 1 0 0 0 1,2,0,2,4,5,5,5,4,1,0,0,0,
356 0 0 0 0 4 0 0 0 4 0 0 0 3 0,0,0,0,4,0,0,0,4,0,0,0,3,
361 1 2 0 0 4 0 0 5 4 0 3 5 0 1,2,0,0,4,0,0,5,4,0,3,5,0,
399 1 2 0 0 0 5 5 5 0 0 0 5 0 1,2,0,0,0,5,5,5,0,0,0,5,0,
313 1 2 0 0 0 5 5 5 4 1 3 0 0 1,2,0,0,0,5,5,5,4,1,3,0,0,
314 1 2 0 0 0 5 5 5 0 1 0 5 0 1,2,0,0,0,5,5,5,0,1,0,5,0,
420 1 2 2 2 4 0 0 5 4 0 0 0 0 1,2,2,2,4,0,0,5,4,0,0,0,0,
288 0 2 0 0 0 0 0 5 4 0 0 0 0 0,2,0,0,0,0,0,5,4,0,0,0,0,
297 1 0 0 0 0 0 5 5 0 0 0 5 0 1,0,0,0,0,0,5,5,0,0,0,5,0,
338 0 0 0 0 0 0 0 5 4 1 0 0 0 0,0,0,0,0,0,0,5,4,1,0,0,0,
402 1 2 0 0 4 0 0 5 4 1 0 0 0 1,2,0,0,4,0,0,5,4,1,0,0,0,
298 1 2 0 0 0 5 5 5 4 1 3 5 0 1,2,0,0,0,5,5,5,4,1,3,5,0,
388 1 2 0 2 0 0 0 5 0 0 0 5 3 1,2,0,2,0,0,0,5,0,0,0,5,3,
573 1 0 0 0 0 0 0 5 0 0 0 0 0 1,0,0,0,0,0,0,5,0,0,0,0,0,
623 0 2 0 2 0 0 0 0 4 1 0 5 0 0,2,0,2,0,0,0,0,4,1,0,5,0,
641 1 2 0 0 4 0 0 0 4 0 0 5 3 1,2,0,0,4,0,0,0,4,0,0,5,3,
645 1 2 0 0 4 0 0 0 4 1 0 5 0 1,2,0,0,4,0,0,0,4,1,0,5,0,
654 1 2 0 0 0 5 5 0 4 0 0 0 0 1,2,0,0,0,5,5,0,4,0,0,0,0,
663 1 0 0 0 4 0 0 0 0 0 0 0 0 1,0,0,0,4,0,0,0,0,0,0,0,0,
668 1 2 0 0 0 0 0 0 4 0 0 0 3 1,2,0,0,0,0,0,0,4,0,0,0,3,
744 1 0 0 0 0 5 5 0 0 0 0 5 0 1,0,0,0,0,5,5,0,0,0,0,5,0,
750 1 2 2 0 0 0 0 0 4 0 0 0 3 1,2,2,0,0,0,0,0,4,0,0,0,3,
443 1 0 0 2 0 0 0 0 0 0 0 0 0 1,0,0,2,0,0,0,0,0,0,0,0,0,
450 1 2 0 0 4 0 0 0 0 1 0 0 3 1,2,0,0,4,0,0,0,0,1,0,0,3,
451 1 0 0 0 4 0 0 0 0 0 0 5 0 1,0,0,0,4,0,0,0,0,0,0,5,0,
456 1 2 0 2 0 0 0 0 0 1 0 5 0 1,2,0,2,0,0,0,0,0,1,0,5,0,
460 1 2 2 2 0 5 5 5 0 1 0 0 0 1,2,2,2,0,5,5,5,0,1,0,0,0,
735 1 2 0 2 0 5 5 5 0 0 0 0 0 1,2,0,2,0,5,5,5,0,0,0,0,0,
192 1 2 0 0 0 5 5 5 0 1 0 0 0 1,2,0,0,0,5,5,5,0,1,0,0,0,
184 1 2 0 2 0 0 0 0 0 0 0 0 3 1,2,0,2,0,0,0,0,0,0,0,0,3,
204 0 2 0 0 0 5 5 5 0 1 0 0 0 0,2,0,0,0,5,5,5,0,1,0,0,0,
Bookmarks