Splitting Data into Groups

Hi all,

Just wondering if someone could possibly tell me how I can take a number of columns with many rows of data and split them into groups of twenty?

I'm uploading the data and it will only allow 20 rows of data at any given time; however, my spreadsheet contains 1700 rows.

Ideally what I would like to do is only show the first twenty and then so on and so forth...

Many thanks

Hi

Say you have your data in column A:C then

H1: 1
I1: =OFFSET($A$1,($H$1-1)*20+ROW()-1,0)
Copy from I1:I20.

This should give you the first 20 rows from column A. Change the number in H1 to 2, and it will give you the next 20 rows.

When you want the data from column B, then change the $A$1 to $B$1 in the formula.

rylo