combining distinct values from a column where rows are otherwise duplicates

combine_dups.R

library(tidyverse)

tibble(group = c("A", "A", "B", "C"),
       major = c("bio", "chem", "bio", "art")) %>% 
  group_by(group) %>% 
  summarise(major = str_c(major, collapse = "/")) %>% 
  separate(major, into = c("major1", "major2"), sep = "/")