AnsweredAssumed Answered

Help on a script (LOOP?)

Question asked by thereddiespirit on Oct 13, 2017
Latest reply on Oct 16, 2017 by tsplatypus

I have been given an organizations history file). The end result for each ID needs to look like:

EEE FFF MSOBU PAN

AWS CHEER

AWS BSU SELF SOPH BSUEC

 

How to I get this non duplicating info but get each club over different SEM#

 

 

CLUBHIST FILE

  IDNO   SEM#   CODE

                   

23,022    911   EEE 

23,022    912   FFF 

23,022    912   MSOBU

23,022    914   PAN

23,023    882   AWS 

23,023    882   CHEER

23,025    885   AWS 

23,025    885   BSU 

23,025    885   SELF

23,025    885   SOPH

23,025    892   AWS 

23,025    892   BSU 

23,025    892   SELF

23,025    892   SOPH

23,025    895   BSU 

23,025    895   SELF

23,025    902   BSU 

23,025    902   BSUEC

Outcomes