how to transpose multiple raws of data in to single coloumn in excel 2007

**abate** · 02-15-2013, 01:24 AM

dear all
could you please help me on how to transpose multiple raws of data in to single coloumn?

for your information i attached the data
thanks

**FDibbins** · 02-15-2013, 02:13 AM

hi and welcome to the form

why do you want to change that table to a single column of info?

**abate** · 02-15-2013, 03:24 AM

thank you for your soonest reply.
i want it to use on the DSSAT software.since the software can only accept the data in single column
thank you

**kvsrinivasamurthy** · 02-15-2013, 03:47 AM

Paste this in B2 cell and drag down.(See attached file.)

=OFFSET(Sheet1!$B$1,INT((ROW()-2)/31)+1,MOD((ROW()-2),31)+1)

Re: how to transpose multiple raws of data in to single coloumn in excel 2007