macro which takes 100 entries in a column and turns them into a 10x10 matrix

[intothewild]

i need to write a macro which takes 100 entries in column in an excel spreadsheet and turns it into a 10x10 matrix on either the same or another sheet.

in vba code:

How do i read the first 10 entries in a column then cut and paste them into another column,
then take the next 10 down of the 90 that are left and put them in the column to the right of
the first 10 i took away.

Then what happens when theres 110 in the column and i need to have a 11x10 matrix?

cheers