perfect. thank you Andy!


reshape() should do it: 

> d 
V1 V2 V3 V4 V5 
1 A1 B1 C1 D1 E1 
2 A2 B2 C2 D2 E2 
3 A3 B3 C3 D3 E3 
> d2 <- reshape(d, varying=list(names(d)[1:4]), direction="long")[c(3,1)] 
> d2[order(d2$V5),] 
V1 V5 
1.1 A1 E1 
1.2 B1 E1 
1.3 C1 E1 
1.4 D1 E1 
2.1 A2 E2 
2.2 B2 E2 
2.3 C2 E2 
2.4 D2 E2 
3.1 A3 E3 
3.2 B3 E3 
3.3 C3 E3 
3.4 D3 E3 

Andy 

> From: jose silva 
> 
> Dear all: 
> 
> I have this: 
> 
> A1 B1 C1 D1 E1 
> A2 B2 C2 D2 E2 
> A3 B3 C3 D3 E3 
> 
> And I want this 
> 
> A1 E1 
> B1 E1 
> C1 E1 
> D1 E1 
> A2 E2 
> B2 E2 
> C2 E2 
> D2 E2 
> A3 E3 
> B3 E3 
> C3 E3 
> D3 E3 
> 
> Example: 
> 
> m<- matrix(1:15,nrow=3,byrow=T) 
> m 
> v<- unlist(list(t(m[,1:4]))) 
> u<- rep(c(5,10,15),c(4,4,4)) 
> data.frame(v,u) 
> 
> This is the result I want but I would like to learn a simpler 
> way to do it. 
> Any clue? On the other hand, how can I reorganize the data in 
> the way it was in the begining? I hope someone can help me on this... 
> Thanks in advance  
> 
> j. silva 
> [[alternative HTML version deleted]] 
> 
> ______________________________________________ 
> R-help@stat.math.ethz.ch mailing list 
> https://stat.ethz.ch/mailman/listinfo/r-help 
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html 
> [[alternative HTML version deleted]] 
> 
> ______________________________________________ 
> R-help@stat.math.ethz.ch mailing list 
> https://stat.ethz.ch/mailman/listinfo/r-help 
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html 
> 
> 
> 



------------------------------------------------------------------------------ 
Notice: This e-mail message, together with any attachments, ...{{dropped}}


