My data looks like this:

a b c
smith mary english
smith mary math
smith mary science
jones fred english
jones fred math

I would like to end up like this:

a b c d e
f g
smith mary english math science etc.
jones fred english math science etc.

Is there a formula that will do this? Obviously, it would have to check
when the name (both last and first) changes. Thanks in advance.