I am attempting to concatenate multiple values into 1 cell. I need to concatenate the values in column C (Points) based on the values in column A and B (NAME,ID). I have more than 200 records that I need to concatenate the lists for and doing it manually would take a long time, hoping to find a shortcut . My data like below format.
[TABLE="class: grid, width: 500, align: center"]
NAME
[/td][td]ID
[/td][td]POINTS
[/td][/tr][tr][td]ROY
[/td][td]JK01
[/td][td]10
[/td][/tr][tr][td]ROY
[/td][td]JK01
[/td][td]25
[/td][/tr][tr][td]ROY
[/td][td]JK02
[/td][td]28
[/td][/tr][tr][td]JAMES
[/td][td]PI09
[/td][td]5
[/td][/tr][tr][td]JAMES
[/td][td]PI09
[/td][td]18
[/td][/tr][tr][td]JAMES
[/td][td]PI09
[/td][td]98
[/td][/tr][tr][td]JAMES
[/td][td]PI09
[/td][td]87
[/td][/tr][tr][td]TONY
[/td][td]IY67
[/td][td]58
[/td][/tr][tr][td]TOM
[/td][td]IESJ
[/td][td]97
[/td][/tr]
[/TABLE]
I want Output like, Concatenate only 3rd value.
[TABLE="class: grid, width: 500"]
NAME
[/td][td]ID
[/td][td]POINTS
[/td][/tr][tr][td]ROY
[/td][td]JK01
[/td][td]1025
[/td][/tr][tr][td]JAMES
[/td][td]JK02
[/td][td]5189887
[/td][/tr][tr][td]TONY
[/td][td]IY67
[/td][td]58
[/td][/tr][tr][td]TOM
[/td][td]IESJ
[/td][td]97
[/td][/tr]
[/TABLE]