Put this in cell B2
=OFFSET($A$1,ROW(A1)-1+(COLUMN(A1)-1)*4000,0)

Copy down 4000 rows, and across as desired/needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Piia" wrote:

Hi,

I have a column with over 200 000 rows. I need to transfer values from this
column to multiple columns so that values from Column A rows 1-4000 go to
Column B (rows 2-4001) , values from Column A rows 4001-8000 go to column C
(rows 2-4001), values from Column A rows 8001-12 000 go to column D (rows
2-4001) etc.

How to make this easily?

Thanks a lot for the help!

-Piia