How to split a file into several files by macro tool? Please help

[LeiCheng]

Hi, Can someone solve this question? I have a file as attached, and want to split it by full name or Chinese name，ensure that there are no duplicate contents in each field of full name or Chinese name. Acutally I have no idea of how many times of  the duplicates will be before I get the real file, so I guess may need Macro tool to solve this problem, but have idea how to set the macro. I attached the input and wanted output (the output should be 5 excel files). Thanks.

input:

outputs:

[dreldrel]

You could unique tool in Alteryx to help you remove the duplicates, just select the columns you want to be unique. If this helps, feel free to like the comment and select it as the solution.

[Qiu]

@LeiCheng 
I have a few question about your output.
1. What is the duplicate criteria?
You said "ensure that there are no duplicate contents in each field of full name or Chinese name. " but looking at Excel #1, the Chinese Name are same for the 3 records.
So actuall you mean "ensure that there are no contents that duplicates both for full name and Chinese name. "

2. What is the group cretiria?
I can see ID#1 is not duplicating with any other records, if we look at both full name and Chinese name. 
So the grouping can vary actually? no need to be same as your sample output?
need a more details for the logic in your current sample grouping.