<tbody>
Hello,
I want to create a table which concatenates the values of column A and B into C (see below).
For this, I use the formula: =IF(A1=B1,A1,CONCATENATE(A1,B1))
The IF statement is to filter out the double values (so that B and B becomes a single 'B').
However, I want to have a...