how to split one column into two and group by id

group split r
sql split column into multiple columns based on value
split dataframe into multiple data frames r
r split data into groups
sql split column into multiple columns based on delimiter
r split dataframe by multiple columns
how to separate one column into two in sql
split one column into two dplyr