Rearranging a Text File.

[vidyashankara]

I have the Following text file

[code]
1 A1 B1 C1 //first row in matrix 1
1 A2 B2 C2 //second row in matrix 1
1 A3 B3 C3 //third row in matrix 1
2 A1 B1 C1 //first row in matrix 2
2 A2 B2 C2 //2nd row in matrix 2
2 A3 B3 C3 //3rd row in matrix 2
3 A1 B1 C1 //first row in matrix 3
3 A2 B2 C2 //2nd row in matrix 3
3 A3 B3 C3 //3rd row in matrix 3
[/code]

I want to rearrage it to
[code]
1 A1 B1 C1 A2 B2 C2 A3 B3 C3 //all the coordinates of matrix 1
2 A1 B1 C1 A2 B2 C2 A3 B3 C3  //all the coordinates of matrix 2
3 A1 B1 C1 A2 B2 C2 A3 B3 C3  //all the coordinates of matrix 3
[/code]

How do i do this dynamically? There can be any number of matrices...


Thanks

[vidyashankara]

[code]
1 A1 B1 C1 1 A2 B2 C2 1 A3 B3 C3 //all the coordinates of matrix 1
2 A1 B1 C1 2 A2 B2 C2 2 A3 B3 C3  //all the coordinates of matrix 2
3 A1 B1 C1 3 A2 B2 C2 3 A3 B3 C3  //all the coordinates of matrix 3
[/code]

Can atleast this be done? all the elements of the first 3 rows into the first line, second 3 rows into the second line?