Merge common name

[rojan]

Hi ,

I need a help to resolve below issue . 

	Problem
	Name	amount
1	Diversifying	300
2	Diversifying prospectus	200
3	Diversifying strategies	500

I want to merge below input with common name and get total amount

Desired output
Diversifying	1000

regards

Rojan

[AbdulBasit]

Use a Text to Column tools and select a space bar as a delimiter.

and if you find this helpful mark it as accepted solution

[anandshingi]

I assume you may have another row that does not contain 'diversifying' and you want to avoid that. 

1. use the formula tool and add new column with formula contains[Name] = ''diversifying''. 

2. Use Summarize tool to sum data. group by newly added column. 

Cheers 

[rojan]

Hi,

Can you please show me the formula, I am getting error while I apply the way what you said

Regards

Rojan

[atcodedog05]

Hi @rojan 

Here is dynamic solution using Fuzzy matching this should work for different common word changes.

Workflow:

Hope this helps : )