Solved: Split cell contents into multiple rows

[bugsyb6]

This is my first post here so I apologize if it's not quite right.

I'm running Excel 2003 and only know very basic VBA. I found something similar to my issue in another post but have no idea how to make it work for my situation.

Here's the deal. I have a workbook with one worksheet holding data that is being used for a look up on another worksheet. My issue is that some of the data in the holding worksheet has multiple values in cells in column E. I need that data split out into separate rows so there is only one value in column E and the values in the remaining columns in that row get copied. I've attached an example of what I'm looking for.

Can anyone show me how to make this happen?

Thanks -
Pam