How to take only unique name in a column

[Pandey19]

I've my input like below

Name	Sub
R-10	abc
R-10	def
R-10	fg
R-10	sd
R-10	q332
R-10 Total
R-20	fsrw4
R-20	we3
R-20	ht
R-20 Total

And i wanted something like below where one unique Name will appear only in first row and rest should be blank.

Name	Sub
R-10	abc
	def
	fg
	sd
	q332
R-10 Total
R-20	fsrw4
	we3
	ht
R-20 Total

[atcodedog05 · Accepted solution]

Hi @Pandey19 

Here is how you can do it with help of multi-row formula tool.

Workflow:

Hope this helps : )

[Christina_H]

Use a multi-row formula tool to create a new field:

if [Name]=[Row-1:Name] then "" else [Name] endif