Client Data in Columns - how to create a client drop down

I have inherited a project. It involves an Excel spreadsheet that contains unique client data in columns...instead of rows. See below.

Sample.png

The request is that I create a tab...where it will display Column A (names of all data elements)...and the actual client data in the next two columns using some kind of drop down.

Is this even possible?