Concatenate columns from same table

[DustinNg_]

Hi all, 

After using the fuzzy match tool, I got a list of duplicates as below:

ID1	ID2	Name 1	Name 2
0001	0002	John Smith	John
0001	0003	John Smith	JM
0002	0003	John	JM
0004	0005	Will	Wil
0006	0007	Katherin	Kat
0007	0008	Kat	Katherine

My goal is creating a new table that has only 2 columns ( ID, Name) and duplicates are put next and below each other, instead of by pairs. Here is what I mean: 

ID	Name
001	John Smith
002	John
003	JM
004	Will
005	Wil
006	Katherin
007	Kat
008	Katherine

Any idea to achieve this outcome?

Much appreciate your help!!!

[atcodedog05 · Accepted solution]

Hi @DustinNg_ 

Here is how you can do it.

Workflow:

Hope this helps : )

[DustinNg_]

It works.

Thanks a tons buddy! You rock!

[atcodedog05]

Happy to help : ) @DustinNg_ 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!