Good day!
Need someone to have a vba that will consolidate my table.
I have a table column for Site_A(D & E) and Site_B(F & G) which concatenated in column J,
I wanted to separate the rows from other sheet that have duplicate data, here in column J row 1 and 2,
that the text value "ER_XMK2437/HDMA - ER_XMK2488_TN4/HDMB" is actually the same as "ER_XMK2488_TN4/HDMB - ER_XMK2437/HDMA"
it is only name in reverse.
The output is in sheet2.
br,
ivan