Hi @sfluker30 , see this example for work with separate()
function.
colors_df <- data.frame(colors = c("red,green,blue", "orange,purple", "pink,yellow,gray"))
library(tidyr)
colors_df %>%
separate(colors, into = c("color1", "color2", "color3"), sep = ",")
# color1 color2 color3
# 1 red green blue
# 2 orange purple <NA>
# 3 pink yellow gray
Try to put a reproducible example of data and code for better help you all the community.