Schools often send data that is difficult to use and needs re-working. Use Nimbus in it’s secure, walled off environment to fix those files quickly, easily and simply.
Did your school provide a data file with multiple lines for each student? One line for each contact rather than one line for each ID number with contact information on that line? Try this prompt and upload the data:
“This data file has multiple lines for each unique student. The unique identifying field for each student is Student ID. Take this file and consolidate the data into one line that has the student ID teacher etc. and contains additional contact fields on that line to include the extra contacts now included as extra lines in the sheet. When done export it as an xlsx file.”
