Display column order based on single row's values

I have a survey form asking participants of their confidence scores that feeds into a table. Here’s 3 sample questions, all 1-5 score:

• confidence with financials
• confidence with communication
• confidence with strategy

These go into columns B-D. I’d like to then have a way to display, for a single respondent (record), a sorted list view of these 3 columns to show highest to lowest rank.

E.g. someone responds 2, 4, 3 respectively. I’d like to create a table (preferably in Interfaces) that shows:

1. Communication (4)
2. Strategy (3)
3. Financials (2)

Is this possible?