Search Results

Hi Ravinder,

The input that you provided seems to have duplicate 1st and 2nd col combinations.


cat matrix_test
1,a,1a
1,b,1b
1,c,1c
2,a,2a
2,b,2b
3,a,3a
4,d,1a
4,d,1b
5,e,1a...

I want to go from
1,a,1a
1,b,1b
1,c,1c
2,a,2a
2,b,2b
3,a,3a

to

a,b,c
1,1a,1b,1c
2,2a,2b,-
3,3a,-,-


Here is what I tried


awk -F, 'BEGIN {OFS = ","}