Convert rows to columns with the specific conditions

I have a table of rows and 9 columns and I am willing to have each row separated into three columns and three rows. For example:
On A1:I1, I have:

1,2,3,4,5,6,7,8,9

I want to convert this row to three rows and three columns:

1,2,3
4,5,6
7,8,9

Is there any formula to separate above row?

You could put this formula in A2:

=INDEX($D$1:$I$1,COLUMNS($A:A)+(ROWS($1:1)-1)*3)

then copy across into B2:C2, then copy A2:C2 down into row 3.

Hope this helps.

Pete

Thanks. Your folmula as well as works.