I am using this formula:

=SUBSTITUTE(MCONCAT(IF(SUBTOTAL(3;OFFSET(E5:E1075; ROW(E5:E1075)-MIN(ROW(E5:E1075));;1));";"&E5:E1075;""));":";"";1 )

Because of the data, it can produce a result like this:

;L0;L0;AB;AB;L0;AB

Is there a way to modify the formula so that it produces:

;L0;AB

Thank you in advance.