A sheet has data in the following format:
Swan Matthew ICT G
Swan Matthew Maths D
Swan Matthew PE C
Swan Matthew Res Mats C
Swan Matthew Res Mats C
Swan Matthew Science C
Swan Matthew Science C
Taylor Colin Eng Lit. B
Taylor Colin English C
Taylor Colin French B
Taylor Colin Geog B
Taylor Colin ICT E
Taylor Colin Maths B
Taylor Colin PE B
Taylor Colin Res Mats C
Taylor Colin Science C
Taylor Colin Science C
Thomas Helen Art AA
Thomas Helen Eng Lit. AA
Thomas Helen English A
Thomas Helen French B
Thomas Helen History A
Does anyone know how do we change the sheet so that duplicate names are removed and the subjects go across the sheet instead of down?
The required format is
Name Art English English Lit. French History etc etc
Thomas Helen AA AA A B A
Taylor Colin etc etc
Swan Matthew ICT G
Swan Matthew Maths D
Swan Matthew PE C
Swan Matthew Res Mats C
Swan Matthew Res Mats C
Swan Matthew Science C
Swan Matthew Science C
Taylor Colin Eng Lit. B
Taylor Colin English C
Taylor Colin French B
Taylor Colin Geog B
Taylor Colin ICT E
Taylor Colin Maths B
Taylor Colin PE B
Taylor Colin Res Mats C
Taylor Colin Science C
Taylor Colin Science C
Thomas Helen Art AA
Thomas Helen Eng Lit. AA
Thomas Helen English A
Thomas Helen French B
Thomas Helen History A
Does anyone know how do we change the sheet so that duplicate names are removed and the subjects go across the sheet instead of down?
The required format is
Name Art English English Lit. French History etc etc
Thomas Helen AA AA A B A
Taylor Colin etc etc