Split one column to several columns

[moishy]

Hi,



I'm looking for a way to split one column with several hundred rows, to several rows containing each 100 rows.

All advice will be appreciated.

[macropod]

You could insert a new worksheet and, on that, insert a formula like:
=OFFSET(Sheet1!$A$1,(COLUMN()-1)*50+ROW()-1,)
where '50' is the number of rows you want to use on that worksheet. Simply copy the formula down to your last row (50 in the example), then across as far as needed.