create new column by using existing value by giving group by values

[Anonymous]

Hi Commnity..!!

Please refer below images,

I have this above data , i have more than 100 rows of data, i have added only few rows in the above pic.

Here is my requirement,

I want to create a new column which groups facebook related fields in single row and remaining in single row,

Ex : 

I want to create new column as Name2

Could anyone please help me out to get the required output.

Thanks in advance..!!

[Anonymous]

Thank you so much for the quick responce..!! @jgeddes 

[jgeddes · Accepted solution]

A calculated column with the following code might work for you...

Name2 = 
IF(
CONTAINSSTRING([Name1], "Facebook"),
"Facebook",
[Name1]
)

If you end up needing to group more rows then you may need to explore using a SWITCH() statement.