Microsoft Excel formulas menu

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:

Step 1

Step 2

Step 3

End result

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.