"Alan Beban" wrote:

RMorahn wrote:
some one sent ma large file with seven recurring fields all in one single
column. Is there some macro that will move each of seven rows to a separate
column and then restart the process with each seventh line to the end of the
file. There are too many items to do this manually? Each field item recurs
every seven lines.
You will be limited by the maximum number of columns in the
spreadsheet--255.

One way: If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, array
enter into a 7-row range of enough columns to accommodate the output

=ArrayReshape(dataRange,7,ROWS(dataRange)/7,TRUE)

Alan Beban


Thanks.

I need a little more help. When I past the command, do I enter it as html or
unicode? I don't know how to name the data range of 4276 lines in column a1.

Can you help me with that?