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?
Bookmarks