Hi,

I was sort of with you until you mentioned concatenation and pattern match and then you lost me completely.

On the basis that a picture is worth a thousand words please upload an example workbook, (we don't need 21000 rows, a handful will do), clearly showing the data and results you expect. Manually enter the results and a note which clearly says in a narrative form how you've arrived at the results.