I need to convert a table of data to columns only

[Pranjali]

When I tried the transpose data option, I could only use convert one row of
data at a time. Is there some way I can display ALL the data in rows to a
single column?

 

[Max]

One way

Assume data is in 3 cols,
eg in A2:C9 you have:

1 2 3
4 5 6
7 8 9
etc

You could place this in any start cell, say in E2:
=OFFSET($A$2,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3))
then just copy down as far as required to exhaust the source data

Adapt it to suit where the anchor cell of the data is, eg: A2 (top left
cell), and the number of cols involved, eg: 3

Pl mark responses which help by clicking the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik