How to get two field values of a form in the same column of excel sheet generated

Question

I created 2 branches from a question in the ms forms, one of them is drop-down, other one is text field, I wish to get the response of both these fields in the same of column of the excel sheet. How should I do that?

Answer 1

Hi @HEMRAJ RAIKWAR

If you click Responses > Open in Excel to export your form responses, the schema of the data export cannot be changed before exporting, one issue is per column.

You may try to change the data schema using formulas, etc.

Could you please share us with a simple sample of your data and the results that you want? This action can help us understand your request better.

The following sample is I created for an example.

The 'Age' column is the respone for one question, the 'School Name' and 'Teacher's Name' is two branches for 'Age' question.

To merge 'School Name' and 'Teacher's Name' into one column of 'Branches', I enter the formula =INDEX($G$2:$H$4,QUOTIENT(ROW(),2),IF(MOD(ROW(),2)=0,1,2)) in cell K2.

For the 'Age' column, I enter the formula =INDEX($F$2:$F$4,QUOTIENT(ROW(),2),1) in cell J2.

Any misunderstanding, welcome to let us know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---