Thank you everyone for your response. However, for my actual spreadsheet
where the rows are of unequal length, I was getting blanks (e.g., while
combining multiple rows into a single column). Thus,  I added just one line
to the final object to avoid getting such blanks.

blankLess <- dat2 [-which(dat2 == ""), ]
#    datX <- dat2 [!(dat2 == "" | is.na(dat2)), ]
# write.csv (blankLess, "RowsIntoSingleColumn.csv")

Many thanks again.

Cheers,
Santana

======================================================

On Sat, Oct 13, 2012 at 8:20 AM, David L Carlson <dcarlson@tamu.edu> wrote:

> This should also work:
>
> Using the dat1 data frame that arun created:
>
> #1
> > dat2 <- t(dat1[,2:4])
> > dim(dat2) <- prod(dim(dat2))
> > dat2 <- data.frame(Col1=dat2, stringsAsFactors=FALSE)
> > dat2
>    Col1
> 1     A
> 2     E
> 3     H
> 4     B
> 5     F
> 6     I
> 7     C
> 8     G
> 9     J
> 10    D
> 11    K
> 12
>
> #2
> > dat3 <- as.matrix(dat1[, 2:4])
> > dim(dat3) <- prod(dim(dat3))
> > dat3 <- data.frame(Col1=dat3, stringsAsFactors=FALSE)
> > dat3
>    Col1
> 1     A
> 2     B
> 3     C
> 4     D
> 5     E
> 6     F
> 7     G
> 8     K
> 9     H
> 10    I
> 11    J
> 12
>
> #3
> > d4 <- data.frame(t(dat2), stringsAsFactors=FALSE)
> > d4
>      X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12
> Col1  A  E  H  B  F  I  C  G  J   D   K
>
> ----------------------------------------------
> David L Carlson
> Associate Professor of Anthropology
> Texas A&M University
> College Station, TX 77843-4352
>
>
> > -----Original Message-----
> > From: r-help-bounces@r-project.org [mailto:r-help-bounces@r-
> > project.org] On Behalf Of arun
> > Sent: Thursday, October 11, 2012 11:26 PM
> > To: Santana Sarma
> > Cc: R help
> > Subject: Re: [R] Columns and rows
> >
> > HI,
> > Try this:
> > dat1<-read.table(text="
> > Names Colx Coly Colz
> > rowName1 A E H
> > rowName2 B F I
> > rowName3 C G J
> > rowName4 D K
> > ",sep="",header=TRUE,stringsAsFactors=FALSE,fill=TRUE)
> >  dat2<-t(dat1)
> > dat3<-dat2[2:4,]
> > dat4<-do.call(rbind,sapply(dat3,list)))
> >
> > row.names(dat4)<-1:nrow(dat4)
> >  dat4
> >  dat4
> > #   [,1]
> > #1  "A"
> > #2  "E"
> > #3  "H"
> > #4  "B"
> > #5  "F"
> > #6  "I"
> > #7  "C"
> > #8  "G"
> > #9  "J"
> > #10 "D"
> > #11 "K"
> > #12 ""
> >
> > data.frame(col1=stack(dat1[,2:4])[,1])
> > #   col1
> > #1     A
> > #2     B
> > #3     C
> > #4     D
> > #5     E
> > #6     F
> > #7     G
> > #8     K
> > #9     H
> > #10    I
> > #11    J
> > #12
> >
> >
> > dat5<-do.call(data.frame,sapply(dat3,list))
> >  dat5
> > #  A E H B F I C G J D K X..
> > #1 A E H B F I C G J D K
> > A.K.
> >
> >
> >
> >
> > ----- Original Message -----
> > From: Santana Sarma <aimanusarma@gmail.com>
> > To: David Winsemius <dwinsemius@comcast.net>
> > Cc: r-help@r-project.org
> > Sent: Thursday, October 11, 2012 11:07 PM
> > Subject: Re: [R] Columns and rows
> >
> > Hi,
> >
> > Trying to give an example here.
> > Say, I have read in a .csv file using read.csv (), and the file
> > contains
> > the following info.
> >
> >
> > Names Col x Col y Col z
> > rowName1 A E H
> > rowName2 B F I
> > rowName3 C G J
> > rowName4 D K
> >
> >
> >
> > Now, this is what is required:
> >
> > 1. Combine/stack/join contents from -
> >               a) multiple rows into one column.
> >
> >
> > That is:
> >
> > A
> > E
> > H
> > B
> > F
> > I
> > C
> > G
> > J
> > D
> > K
> >
> >               b) multiple columns into one row.
> >
> > A B C D E F G H I J K
> >
> >
> > 2. Stack contents from
> >
> > A) multiple columns into one column.
> >
> > A
> > B
> > C
> > D
> > E
> > F
> > G
> > H
> > I
> > J
> > K
> >
> >
> > B) Multiple rows into one row.
> >
> > A E H B F I C G J D
> >
> >
> > Thank you.
> >
> > Cheers,
> > Santana
> >
> > ================================
> >
> >
> > On Fri, Oct 12, 2012 at 1:32 PM, David Winsemius
> > <dwinsemius@comcast.net>wrote:
> >
> > >
> > > On Oct 11, 2012, at 5:55 PM, Santana Sarma wrote:
> > >
> > > > Hi,
> > > >
> > > > Could you please advice some easy way to do the following for a
> > dataframe
> > > > (header=F) having unequal column- & row- length.
> > > >
> > > > 1. Combine/stack/join contents from -
> > > >              a) multiple rows into one column.
> > > >              b) multiple columns into one row.
> > > >
> > > > 2. Stack contents from multiple columns (or, rows) into one column
> > (or,
> > > > row).
> > >
> > > Could _you_ please produce an example.
> > >
> > > Dataframes do not have headers. They do have column names and column
> > names
> > > are required.
> > >
> > > --
> > > David Winsemius, MD
> > > Alameda, CA, USA
> > >
> > >
> >
> >     [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > 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.
> >
> >
> > ______________________________________________
> > 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.
>
>

	[[alternative HTML version deleted]]


