There are a few super-handy timesaving tricks in Excel for when your data is not quite the way you need it to be. The Text to Columns and the Transpose option for the Paste command are two features that could save you from re-typing data that was “incorrectly” captured.
I often see learners capture their questionnaire data incorrectly, for example where a question is asked and then motivation for that answer is required:
Do you like ice-cream and if so what is your favourite flavour?
You might end up with something like the following: