How to take only unique name in a column

Question

I've my input like below

NameSubR-10abcR-10defR-10fgR-10sdR-10q332R-10 Total R-20fsrw4R-20we3R-20htR-20 Total

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

NameSubR-10abc def fg sd q332R-10 Total R-20fsrw4 we3 htR-20 Total

atcodedog05 · Accepted Answer

Hi @Pandey19

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

Workflow:

Hope this helps : )