Hello Community,
I have a situation where I need to combine the records or rows. I am looking for a possible solution.
My source file is as shown below. I need to generate one row per Singer combining all the songs.
| Name | Last Name | Song1 | Song2 | Song3 | Song4 | Song5 |
| Micheal | Jackson | xxx | | zzz | aaa | |
| Micheal | Jackson | | yyy | | | bbb |
| Shakira | Ripoll | 111 | | 333 | | |
| Shakira | Ripoll | | 222 | | | 555 |
| Shakira | Ripoll | | | | 444 | |
The output should look like below.
| Name | Last Name | Song1 | Song2 | Song3 | Song4 | Song5 |
| Micheal | Jackson | xxx | yyy | zzz | aaa | bbb |
| Shakira | Ripoll | 111 | 222 | 333 | 444 | 555 |
Thanks in advance for your input.
BR
Sreekanth
