Hi all, I have 2 datasets I need to combine in order to merge with another
One has 3 columns- ID, synonym ID and duration as shown below, you can see that
the species column has repeats to allow for synonym IDs used by some.
Species Synonym.Symbol Duration AUREO BELLA BRACH5 CASTI2 CAAFA2 Perennial CAAFA2 CAAFC CAAFA2 CAAFI
Is there any way to retain the duration information, but create one column that has ALL the species potential names, without repeats? i.e. combine the species column and the synonym species column, but without a separator (i.e. make a new row) and retain the duration information, as in
Species Duration AUREO BELLA BRACH5 CASTI2 CAAFA2 CAAFC Perennial CAAFAI Perennial
Eventually, this will be used to merge the duration information into a large vegetation analysis database, where some researchers used different IDs for the same species . I did create a list of all the unique names into one column, but don't know how to match the duration values of 2 columns with this new list