move list to columns

[Tesons]

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.

 

[pogiman via OfficeKB.com]

Columns A/B are First/Last Names (or vice versa) and C will be subjects. If
this is sort of a checklist for a name, you may consider using the subjects
as fields.

I have a non-VBA (long-way and a bit tedious) suggestion but let's wait for
others to simplify it.