If I have data like
a <- data.frame(detail=c('pure water','mineral water','wood fire'),2)
b <- data.frame(type=c('water','fire'))
a
## detail X2
## 1 pure water 2
## 2 mineral water 2
## 3 wood fire 2
b
## type
## 1 water
## 2 fire
c <- merge(a,b,all=T)
Ideallly, the result should be R
r <- c[c(1,2,6),c('detail','type')]
r
## detail type
## 1 pure water water
## 2 mineral water water
## 6 wood fire fire