I have a workbook with a table that has headers with names and group. The names column is distinct (no name is repeated) whilst the group column has values (like G1, G2, G3 etc) which are repeated. I want to create 2 lists, the first one of which will allow the user to select a group. The second list will then allow him to select a name from that group. Is this possible? I have been trying to get a solution that works but it seems all of them require that the row values in my group column need to be changed into headers
Edit: More details
Not able to post images due to rep. Here is a link to the setup
The first image shows the data sheet with a table with names, group and ID.
On the user sheet i want to add a data validation list for both group and names. The user selects a group like G2, then under names he gets a list of the people who are in G2 and can select whomever he wants