Merge and Delete

11 views
Skip to first unread message

Chetan s

unread,
Oct 8, 2021, 10:24:32 AM10/8/21
to OpenRefine
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

Reply all
Reply to author
Forward
0 new messages