Hi, Try: dat1<- read.table(text="name Value abc BXR abc DHH abc DHK def DHK def DSL ghi DSL abc DSM def DSM ghi DSM def DSS ghi DSS ghi DST abc DIW abc DIL ghi DIL",sep="",header=TRUE,stringsAsFactors=FALSE)
aggregate(name~Value,data=dat1,paste,collapse=" ") #or library(plyr) ddply(dat1,.(Value),summarize, name=lapply(list(Value),paste,collapse=" ")) A.K. Hi, I want my output to be like this: Value BXR abc DHH abc DHK abc def DSL def ghi DSM abc def ghi DSS def ghi DST ghi DIW abc DIL abc ghi My input dataset is this with colnames name and Value: name Value abc BXR abc DHH abc DHK def DHK def DSL ghi DSL abc DSM def DSM ghi DSM def DSS ghi DSS ghi DST abc DIW abc DIL ghi DIL ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
