I know very little about excel and stumbled across this forum while trying to Google for an answer to my problem. Was hoping you all might be able to help.

I have an excel file like this....
A1---------------B2
Bob Jones-----0;234
Judy Smith----12;14

And I would like to convert that to....
A1--------------B2
Bob Jones----0
Bob Jones----234
Judy Smith---12
Judy Smith---14

Is this possible? The B2 column would have far more numbers and semicolons than the example. I found out ways to separate the semi colons into columns. And the paste special feature with Tranpose. But that puts all the names into Columns, rather than rows. Any help would be much appreciated.