I have a file like the one below.
11111 |Y |N |N |N |aaaaa| | |
11111 |N |Y |N |N | |pre | |
11111 |N |N |Y |N | | | |FBBr
Now I want a file which combines all the three rows and it should be like the one below.Except the cstmr_id all other fields should be appended as it is
11111 |Y |N |N |N |aaaaa| | | N |Y |N |N | |pre | | N |N |Y |N | | | |FBBr
Can someone help me in acheiving this using shell scriptiong or sql?
Thanks in advance.