In Excel, how do I move answers from other column to same question under another column, can any one guide the exact formula to achieve this? See example below what needs to be achieved as shown in picture.

Excel to move column

  • Welcome. This site is about web applications. The answer will be about Google Sheets. Not Excel. – marikamitsos Jan 10 at 5:50
  • I’m voting to close this question because it's not about using a web application as is defined in help center. – Rubén Apr 1 at 16:37

Please use the following FLATTEN formula


enter image description here



enter image description here


Not the answer you're looking for? Browse other questions tagged or ask your own question.