=OFFSET($A$1;ROWS($1:1)-1+(200)*(COLUMN()-1);0)

Glad you got it up to suit your actuals (including the delimiter change -
semicolon instead of comma - to suit your excel settings). But there were
*no* errors earlier with the suggested expression. What I illustrated works
"as-is" with the stated assumption on where source data starts. You could
actually have placed the same extract formula in any starting cell on the
sheet (not necessarily in B1), then just copy across from there & fill down
to populate a 100 C x 200 R grid. The last zero in the OFFSET expression is
optional, but the comma (in your case semicolon) is required.

And since there were no errors earlier, would you care to take a moment to
press the "Yes" button below?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Magnus" wrote:
=OFFSET($A$1;ROWS($1:1)-1+(200)*(COLUMN()-1);0)

This worked as I wanted =)

Thank you