Convert single row into multiple row & column

Closed
Hiren - Dec 30, 2010 at 04:42 PM
 Sastry - Dec 31, 2010 at 02:08 AM
Hello,


I want to convert single row into multiple row.

Single Row (4225 length)

output file : 65*65 matrix (65 columns and 65 rows)


Simple Example :

Single Row (length 9) = 1 2 3 4 5 6 7 8 9

output matrix : 3*3 matrix

1 2 3
4 5 6
7 8 9

Thanks in advance

1 response

To my knowledge, MSWord can do this quickly.

select the entire row with 4225 length. (I suppose some separator like "Space" is there in between.)

Then select Convert Text to Table under Table tab in Insert tab.

Type "Space" in Other under "Separate text at" field and then select Number of Columns as 65 and then click on OK.

This will convert your sincle row into 65 columns and obviously your data is in 65*65 matrix.
0