I have a problem with my google sheet. I hope someone can help me or point me in the right direction.
I auto create a table with following structure:
Question | Answer a | Answer b | Answer c | Right Answer
ex Question | ex Answer | ex Answer | ex Answer | ex right Answer
ex Question | ex Answer | ex Answer | ex Answer | ex right Answer
etc
I want to format it in the following structure:
Question 1 | Answer 1a | Answer 1b | Answer 2b | Right Answer 1 | Question 2 | Answer 2a etc
Is there any function or way to make it happen in google sheets?
To make one table in one row
Thank you in advance!