Using multiple columns to identify single dropdown

Is it possible to use multiple columns ti identify a single dropdown?

For example, in the picture, I would like a single dropdown with First Name and Last Name

Hi @pacman
No, you should use a database view to concatenate the columns into one.
There’s a request open for allowing dropdown options to come from a query:
https://github.com/metabase/metabase/issues/6820 - upvote by clicking :+1: on the first post