AnsweredAssumed Answered

Excel help ... for creating CSV SIS files

Question asked by ed0046157 on Sep 12, 2016
Latest reply on Sep 15, 2016 by mdeeprose

Hi

I've got what I'd imagine is a fairly standard set of data:

 

I have a list of student IDs and a list of courses they all have to be added to.

 

I need a couple of nested loops to combine the two into a CSV file (anyone got a handy script already??) - or does Excel have some feature that will let me do that even more easily??

 

Can do it on Excel on Mac or Windows, if one does it better than the other! (Or Open Office, which I have lurking somewhere )

 

Emma

Outcomes