Match single criteria and return multiple rows in excel

Hello all,

I figure myself to be fairly knowledgeable with excel but I am stuck. I am using excel to import invoices into Quick books but each item must be separate lines. Here is my problem. Here is an example of what my data will look like:

A B C D
Item Total Quantity Total Price Answer
1 ABN 1030 & ABN 1031 5 22.84 ABN 1030
2 ABN 1031


I need a formula that will read column A1 and return values in separate cells like in D1 and D2. The way I'm thinking is the formula would be have to be in D1 and return values in both D1 and D2. As in some kind of If formula, if a1=whatever, then d1 AND d2 = some value

Please let me know if this is possible as it would save us thousands of dollars in labor costs

Attached is an example. I want the cells in column D to be based off the cells in column A. If A if a combination of two items, I need the items to be show in column D but on separate lines. Is there a way to return data on multiple lines with the formula in only one?

In this instance it wouldn't. A4 would be an example because the "item name" is actually a combination of 4 items that cannot be split using the text to columns.