How to create output that equals answer of Q1 but if Q1 = empty, it's answer of Q2

Dear all,

I have different questions but not all are visible to the respondent.
I would need to create an output (for example an embedded data in survey flow) that would be the following:

If scale question 1 has an answer, the output should include this answer, if it's empty than the output should include the answer of scale question 2. If both are empty the output should equal N/A
Currently we use this formula in Excel to receive the desired output.

=IF(NOT(ISBLANK(A1));A1;IF(NOT(ISBLANK(B1));B1;"n/a"))

with column A having the answers of Q1 and column B having the answers of Q2

The goal would be to have a seperate column in the reporting section of Qualtrics that would have this logic (so we don't have to manually do it in Excel afterwards).

Thanks in advance!!!