Remove not duplicates

[Ultralightbeam]

Hello guys I want to delete entire row with single entry

Input:

Name	ID	Date	Grade
Alyssa	1	2021-01-22	4
Alyssa	26	2021-02-05	5
Alyssa	45	2021-01-08	4
Dy	6	2021-01-22	4
Edrose	33	2021-02-05	5
Fatima	9	2021-01-22	5
Fatima	37	2021-02-05	5

Desired Output:

Name	ID	Date	Grade
Alyssa	1	2021-01-22	4
Alyssa	26	2021-02-05	5
Alyssa	45	2021-01-08	4
Fatima	9	2021-01-22	5
Fatima	37	2021-02-05	5

[Emil_Kos]

Hi @Ultralightbeam,

Can you review and let me know if this works:

Output:

[Ultralightbeam]

@Emil_Kos Thank you so much for saving me!! Have a great day!!

[Emil_Kos]

Hi @Ultralightbeam,

No worries. Actually, without your detailed explanation, I would never complete it.

I wished more people would provide so granular level of detail. 

Wish you luck and I hope I will have the opportunity to help you more in the future. 

[Ultralightbeam]

@Emil_Kos I just notice that if the provider is at bottom part it shouldn't be included on the output.

I have included sort by provider

[Emil_Kos]

Hi @Ultralightbeam,

That means it works for you now or you need any help? 😆

[Ultralightbeam]

@Emil_Kos 

I am about to give up lol

Output should still be the same as yours even a row with same provider is at bottom part

[Emil_Kos]

Hi @Ultralightbeam,

I made small change in the sort order

[Ultralightbeam]

I just figured out i was ascending a different column.

 its 12 am here and been doing alteryx for more than a day now. Thanks for your help I will sleep now and continue tomorrow.

[Emil_Kos]

Hi @Ultralightbeam,

Sleep well 🙂 

I am not sure if due to the time zone difference I will be able to help you but feel free to shout for me if needed 🙂