I have a dataframe like this
| NAME1 | NAME2 | NAME3 |
| ----- | ----- |------ |
| NA |STRING1|STRING2|
|STRING3| NA |STRING4|
|STRING5| NA | NA |
And i want to concatenate columns omiting NA's , like this |
NAME1 | NAME2 | NAME3 |CONCAT |
| ----- | ----- |------ |------ |
| NA |STRING1|STRING2|STRING1, STRING2|
|STRING3| NA |STRING4|STRING3, STRING4|
|STRING5| NA | NA |STRING5|
I tried with unite function of tidyr , but that does not exclude the NA's
