Like this:
1) Data on the left
2) Set up the a row and column of reference numbers like I did along the top and left for how many datapoints you want in each column.
(edit: Note that the column starts at 0 and goes to how many cells per column you want minus 1. Then the row at the top starts at zero and goes up in multiples of how many cells per column you want. So if you wanted each column to have, say, 35 cells you'd make the reference on the left go from 0 to 34, and the reference across the top go 0, 35, 70, 105, etc.)
3) Follow the offset formula I showed, noting the direct/indirect referencing.