I am trying to concatenate unique column text into a single cell. After spending an afternoon researching, I can now concatenate all the text in different column cells and remove duplicates. However, if one of these cells is empty, I get a blank value.
as an example, I want to concatenate all the letters in one cell using this formula: =TEXTJOIN(",",TRUE,IF(COLUMN(A2:D2)=MATCH(A2:D2,A2:D2,0),A2:D2,""))
A B C D E
<tbody>
</tbody>
<tbody>
</tbody>
What do I need to add such that it ignores blank cells?
as an example, I want to concatenate all the letters in one cell using this formula: =TEXTJOIN(",",TRUE,IF(COLUMN(A2:D2)=MATCH(A2:D2,A2:D2,0),A2:D2,""))
A B C D E
a | a | g | z | a,g,z |
<tbody>
</tbody>
a | g | z | #N/A |
<tbody>
</tbody>
What do I need to add such that it ignores blank cells?