Hi, May be this helps. dat1<- structure(list(trialnumber = 1:9, Control = c(0L, 1L, 0L, 0L, 1L, 0L, 1L, 0L, 0L), HC = c(0L, 0L, 1L, 1L, 0L, 0L, 0L, 0L, 1L ), LC = c(1L, 0L, 0L, 0L, 0L, 1L, 0L, 1L, 0L), pleasantness = c(3L, 3L, 2L, 2L, 3L, 4L, 3L, 3L, 2L)), .Names = c("trialnumber", "Control", "HC", "LC", "pleasantness"), class = "data.frame", row.names = c(NA, -9L))
library(reshape2) res<- melt(dat1,id.vars=c("trialnumber","pleasantness")) colnames(res)[3]<- "type" A.K. I have an experiment where people get to see a picture which is a control, HC or LC picture. They then have to rate its pleasantness. I tried to change the data so that I would get one column (for example "type" with 3 groups) instead of the 3 separate columns. Can anyone help me out? Thanks trialnumber Control HC LC pleasantness 1 0 0 1 3 2 1 0 0 3 3 0 1 0 2 4 0 1 0 2 5 1 0 0 3 6 0 0 1 4 7 1 0 0 3 8 0 0 1 3 9 0 1 0 2 ______________________________________________ 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.