Dynamic list with multiple criteria

Google search - how to create a dynamic list without blank in excel

The first result in the google search has been referenced for creating a dynamic list as attached in a sample worksheet(not a drop down though). Only problem is I need it to list the 7 names category wise like A B and C. My desired result is highlighted in yellow in column F. I want this to flow as a formula in column E.