I dont' think even the mighty ASAP utilities can help me with this one.

I have a spreadsheet and each line looks something like this....

JOHN SMITH A333 B404 A405 C404
PETER GRIFFIN A202

When infact I need it to look more like this....

JOHN SMITH A33 1
JOHN SMITH B404 2
JOHN SMITH A405 3
JOHN SMITH C404 4
PETER GRIFFIN A202

Easy to do by hand when there are 20 records, but I have thousands.

How hard would this be?