Create a Dynamic Drop Down List

Hello All!

I have test results that I am trying to create a summary for. The issue that I need help with is a dynamic dropdown.

If a student attempts the test more than once, I would like for a drop down to appear in the column to the right of their name, with the ability to select the other test attempts. In the raw data it appends a (2) to their name for the 2nd attempt for easy identification. I would like for the drop down to populate with those iterations. I have attached an example excel file along with more description as to what exactly I am looking for.

Please let me know if you need more information from me that wasn't in the workbook.
example_drop_down.xlsx