Shell Programming and Scripting

Code:

awk -F "          " 'NR>2{t[$1]?t[$1]=t[$1]","$2:t[$1]=$2;next}1 END{for (i in t){print i FS t[i]}}' file

Thanks thanhdat, but for few cases the space was less between 2 fields.
I used Danmero code and it was resolved

---------- Post updated at 07:17 AM ---------- Previous update was at 06:17 AM ----------

Thanks Danmero!

The output is as desired

Hi Danmero,

I have another need based on this output.
Instead of space between 2 columns I need any delimeted like "|" character.
Because I need to insert these values into another table so it will be useful.
Is that possible?

Thanks in advance!

---------- Post updated at 02:29 AM ---------- Previous update was at 01:49 AM ----------

I have edited the command as below:

Code:

awk -F " " 'NR>2{t[$1]?t[$1]=t[$1]","$2:t[$1]=$2;next}1 END{for (i in t){print i"|"FS t[i]}}' prod_data.out > res1.out

I got the output fine.

I just noticed that the first few values of prod_data file have not got concatenated

why do they get skipped?

The code will skip(print only) the first 2 lines base on your data sample from https://www.unix.com/shell-programmin...#post302345773