View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How to convert vertical blocked list to horizontal list?

One way ..

Assuming source data in A1 down, with data in 10 lines per group viz:
A1:A10, A11:A20, A21:A30 etc

Put in B1:
=INDEX($A:$A,ROW(A1)*10-10+COLUMN(A1))
Copy B1 across by 10 cols to K1, then fill down until zeros appear,
signalling exhaustion of data. Cols B to K will return the required results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"G Lykos" wrote:
Greetings! Have an Excel database that has ten lines per entry in one
column in a symmetric structure - first line is name, second line is
address, etc. Would like to rotate the data so each entry is one row, with
the lines in successive columns 1, 2, etc. Can this be accomplished using
standard worksheet functions? If not, is there some code available?

Thanks,
George