Convert single row into multiple row & column

Closed
Report
-
 Sastry -
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 reply

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.