Analyzing badly captured survey data

All of us conduct surveys, get feedback forms or scoring sheets filled. When data is captured in Excel, we typically use Excel Pivot Tables to analyze it.

But what if the data is captured as a list of textual values like this? Many professional survey applications often dump the data in this type of format.

image

Here is a very simple but extremely useful way of analyzing such badly captured data.

Continue reading