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.

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.


Tesons wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1