Transposing columns with awk

Shell Programming and Scripting
1

I want a sweet simple time efficient awk script in online which gets output

001_r 0.0265185 0.0437049 0.0240642 0.0310264 0.0200482 0.0146746 0.0351344 0.0347856 0.036119 1.49

firstcoloumnvalue allvaluesof 'c' in one row

001_r : 002_r    c: 0.0265185    N: 548
001_r : 007_r    c: 0.0437049    N: 548
001_r : 014_r    c: 0.0240642    N: 548
001_r : 015_r    c: 0.0310264    N: 548
001_r : 018_r    c: 0.0200482    N: 548
001_r : 020_r    c: 0.0146746    N: 548
001_r : 027_r    c: 0.0351344    N: 548
001_r : 034_r    c: 0.0347856    N: 548
001_r : 046_r    c: 0.036119     N: 548
001_r : 129_r    c: 1.49         N: 548

please help me

2

try:

awk -F "[: \t]" '{f_val[NR]=$1;c_val[NR]=$10} END { printf "%s ", f_val[NR];for (i=1;i<=NR;i++) {printf "%s ", c_val}} ' file
3

And where 002_r, 007_r etc. are coming from?

4

yes, but i am feeding them one by one and later extracting required data

5

Below code for your reference, but you still need tell us how to generate 2nd column and last column in output.

awk '{for (i=2;i<=NF;i++) printf "%s : 002_r\tc: %s\tN: 548\n",$1,$i}' urfile

001_r : 002_r   c: 0.0265185    N: 548
001_r : 002_r   c: 0.0437049    N: 548
001_r : 002_r   c: 0.0240642    N: 548
001_r : 002_r   c: 0.0310264    N: 548
001_r : 002_r   c: 0.0200482    N: 548
001_r : 002_r   c: 0.0146746    N: 548
001_r : 002_r   c: 0.0351344    N: 548
001_r : 002_r   c: 0.0347856    N: 548
001_r : 002_r   c: 0.036119     N: 548
001_r : 002_r   c: 1.49 N: 548
6

thanks!