Please find the reprex/starting code below:
Basically I am trying to obtain the following output
# 2 columns containing cyl and combi
expected_output = 
cyl                                                                  combi
4                                                      Datsun 710 _ 22.8
6 Mazda RX4 _ 21,Mazda RX4 Wag _ 21,Hornet 4 Drive _ 21.4,Valiant _ 18.1
8                                               Hornet Sportabout _ 18.7
Steps following as below:
library(tidyverse)
# To convert index into columns
df <- mtcars %>% 
      head() %>%
      tibble::rownames_to_column("cars")
# concatenate columns
df["combi"] <- paste(df$cars,"_", df$mpg) 
#Struck from here as it involves concatenating strings of a column and summarising them vy concatenating
## Attempts to resolve 
df %>%
  group_by(cyl) %>%
  summarise()
df_ <- df %>% 
  pivot_wider(names_from = cyl, values_from = combi) %>% 
  mutate(mycol = coalesce(`6`,`4`,`8`)) 
x = df_ %>% 
select(`6`) %>% stringr::str_c(sep = "_")
assertr::col_concat(df, sep = "")