Power BI HLOOKUP Equivalent - Data Spread Across Multiple Columns

Hi there brains trust!   I am working with a dataset containing questionnaire responses, with questions and answers not being consistently captured.    Question 1 always corresponds to Answer 1, ...