0

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

2
  • Welcome. This site is about web applications. The answer will be about Google Sheets. Not Excel. Commented Jan 10, 2021 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. Commented Apr 1, 2021 at 16:37

1 Answer 1

1

Please use the following FLATTEN formula

=FLATTEN(A2:C4)

enter image description here

OR

={"Questions";FLATTEN(A2:C4)}

enter image description here

1

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