Merge and Delete

[Chetan s]

hello All,

I am trying to figure this usecase out. 

Example 

Lets say I have 2 rows with 2 columns

First column is named “Name”

2nd Columns is named “ Games”

In my case both rows have same name. Example

Row 1.     John.  - Basketball

Row 2.  John - IceHockey

I want to create a third column called as “Games2” and merge the data so it looks like

John Basketball Ice hockey

Plus delete the row 2.

How can I achieve this. 

Thanks