W
wooster
Hi,
Wondering if anyone can help me? I have a series of data that looks
like:
Pupil_ID Code Subject Teacher
980656 BEL004 Information Technology BARR, Iain
980656 BEL004 Biology FRENCH, Julia
980656 BEL004 Business Vocational RIMMINGTON, Mark
980656 BEL004 Business Vocational JACKSON, Barry
980656 BEL004 Home Economics AICKEN, Mary
980656 BEL004 Physical Education WELLS, Alan
980656 BEL004 Careers WARD, Graham
980656 BEL004 English AGABA, Faith
980656 BEL004 Mathematics KRAUSE, Michael
980897 BRI001 Art GRAHAM, David
Each child will have a varying number of records dependent upon the
number of subjects they study. For each student I need to display the
data as a single record.
Pupil_ID, Code, Subject1, Teacher 1, Subject2, Teacher2 etc.
I can't seem to use the Transform option as I'm not aggregating any
data.
I'm having to use the data for a mail merge and I need all the data for
each student accessible in one record. If anyone has any other
suggestions I'd appreciate them as I've got so blinkered on this issue
now.
Thanks
Woo
Wondering if anyone can help me? I have a series of data that looks
like:
Pupil_ID Code Subject Teacher
980656 BEL004 Information Technology BARR, Iain
980656 BEL004 Biology FRENCH, Julia
980656 BEL004 Business Vocational RIMMINGTON, Mark
980656 BEL004 Business Vocational JACKSON, Barry
980656 BEL004 Home Economics AICKEN, Mary
980656 BEL004 Physical Education WELLS, Alan
980656 BEL004 Careers WARD, Graham
980656 BEL004 English AGABA, Faith
980656 BEL004 Mathematics KRAUSE, Michael
980897 BRI001 Art GRAHAM, David
Each child will have a varying number of records dependent upon the
number of subjects they study. For each student I need to display the
data as a single record.
Pupil_ID, Code, Subject1, Teacher 1, Subject2, Teacher2 etc.
I can't seem to use the Transform option as I'm not aggregating any
data.
I'm having to use the data for a mail merge and I need all the data for
each student accessible in one record. If anyone has any other
suggestions I'd appreciate them as I've got so blinkered on this issue
now.
Thanks
Woo