Hello,
I have a very large text file with 500 000 columns and 220 rows
inside each columns i have 4 different values like this
```

> Sample_name "VAR1" "VAR2"
> Sample1 "-0.0570 0.0113 1.035 0.061" " -0.3631 0.0065 0.842 0.045"
> Sample2 "-0.0334 1.0000 0.013 0.813" "-0.0604 0.9639 0.052 0.764"

Now i want to transform it like that

Var_name Sample_name V1 V2 V3 V4
VAR1 Sample1 -0.0570 0.0113 1.035 0.061
VAR2 Sample1 -0.3631 0.0065 0.842 0.045
VAR1 Sample2 -0.0334 1.0000 0.013 0.813

Any idea about how can I do this please ?



Source link