Hi,

I wish to extract student information from an Excel file and redisplay some of the data in a different format and would like to know how to go about doing it, or even if it's at all possible to do so.

The file comes to me in a format such as:

Student Number Name Subject Code
BRO12345 Brown ENG100
BRO12345 Brown ADM234
BRO12345 Brown HUM222
BLA22222 Black ENG100
BLA22222 Black MAT334

I wish the format to be as follows. That is, 1 complete student record per row.

Student Number Name Subject1 Subject2 Subject3 Subject4
BRO12345 Brown ENG100 ADM234 HUM222
BLA22222 Black ENG100 MAT334
GOR23456 Gorman ART111 ENG100 ADM234 PHY110

As you can see, not all students would be doing exactly the same subjects or even the same number of subjects.

I would appreciate any assistance.

Thanks,

Clare