Extracting text string from cell with no delimiters

Hi

I am looking to extract non-delimited values from a cell.

In my attached test data

Column A is the product code
Column C is the non-delimited product codes in a customer order
Column E through H+ is how I would like the data extraced and displayed.

Out system exports order data showing all ordered products in the same cell with no delimiter.

I am hoping to find a way to search in Column A for a value and if found in Column C it should add that value to a new adjacent cell, for each matched value.

Regards