Splitting columns by , and retaining orginal row information

Hello Everybody,

Recently I posted a question and Stephen was able to help me out with one part of the problem. I have just be informed that it is not enough to split my data by the first column, I need to do a splitting of column A and E with respect to the relative information. An example of my data is attached, along with the orginal and what it should look like after the macro is written. The number of IPIs needs to be the same as the number of protein descriptions. For example,
If in column A row 1there is IPIA,IPIB,IPIC, and IPID. Then in column E row 1 there should be 4 descriptions, protein a, protein b, protein c, protein d. Sometimes there is a premature comma that interupts:
protien a, protein b, protein c, protei,n d. In this case I would need to edit the comma so that only descriptions are there (I may need to do this manually). If someone can come up with a way to split the commas and maintain the protein descriptions associate with the first IPI listed, then I may be able to work with it and manually edit the messed up commas. I should stress that the first IPI in the cell should correspond to the first protein description in the cell. If my attached example does not make sense, please ask me to elaborate. Stephen was of great help before, and I just found out it is not enough.

Thank you all,
Thomas Quinn

Hi

Try this and see how it goes.

rylo