Hello,
I'm in need of some assistance with re-organising our data. We need to transpose and remove duplicates from an excel CSV so it can be accepted by other program or introduced to a PDF form.
We get this:
We need:
Put simply, we need a macro that adds the subject, teacher, assessment, and result to the end of each change of student code and removes the repeated student code, first, last, year, form and house.
Really appreciate anyone's help. I tried editing various macro but cant get anything to work.
Cheers,
Andrew
I'm in need of some assistance with re-organising our data. We need to transpose and remove duplicates from an excel CSV so it can be accepted by other program or introduced to a PDF form.
We get this:
StudentCode | First | Last | Year | Form | House | Subject | Code | Teacher | Assessment | Result |
ABC123 | John | Smith | Year 8 | P3M | MELB | English | BENG | Jane SMITH | On Time | Yes |
ABC123 | John | Smith | Year 8 | P3M | MELB | English | BENG | Jane SMITH | Equipped | Yes |
CBA321 | Thomas | Jones | Year 7 | PN2 | NEWT | Maths | BMAT | Tim APPLE | On Time | Yes |
CBA321 | Thomas | Jones | Year 7 | PN2 | NEWT | English | BENG | Jane SMITH | Ready to learn | Sometimes |
We need:
StudentCode | First | Last | Year | Form | House | Subject | Code | Teacher | Assessment | Result | Assessment | Result | Subject | Teacher | Assessment | Result |
ABC123 | John | Smith | Year 8 | P3M | MELB | English | ENGB | Jane SMITH | On Time | Yes | Equipped | Yes | Maths | Tim Apple | On Time | Yes |
CBA | Thomas | Jones | Year 7 | PN2 | NEWT | Maths | BMAT | Tim APPLE | On Time | Yes | Equipped | Yes | English | Jane SMITH | Ready to Learn | Sometimes |
Put simply, we need a macro that adds the subject, teacher, assessment, and result to the end of each change of student code and removes the repeated student code, first, last, year, form and house.
Really appreciate anyone's help. I tried editing various macro but cant get anything to work.
Cheers,
Andrew