thereddiespirit

Non duplicating field from old excel file

Discussion created by thereddiespirit on Oct 16, 2017
Latest reply on Oct 17, 2017 by thereddiespirit

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

 

INDO 23022     EEE FFF MSOBU PAN

INDO 23023     AWS CHEER

INDO 23025     AWS BSU SELF SOPH BSUEC

 

How do I create a field the will produce that result?

 

 

 

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