I have 50 columns. In column 51 I combined the data of each row into one
cell using the concatenate function. I now want to remove the duplicate data
from each cell.

Should I use something else besides concatenate.

I will also have to combine the data of specific columns and then remove the
duplicate data too. for example column 51 I need the unique data from rows B,
D H AA BB AW AU... and in column 52 I need the unique data from C, G, H, K,
....