2
Hello!
I am working with a spreadsheet in Excel that has this structure:
Coluna_A Coluna_B
A A
B B
C C
C_1 E
D
E
F
What I want is to find a way to assemble a third column, which has data present in the two columns. So:
Coluna_C
A
B
C
E
Note that the sample unit "E" of the "Coluna_b" is in the same row as "C_1" of the "Coluna_a", but still it must be in the "Coluna_c", because it is in both columns. Would anyone know any code to automate this analysis, whether in Excel, or R?