Editing the Data

The given responses are from my survey, "Are You Selfie Ready?" This is a screen shot from my drive.

To prepare these responses for analysis, we need to download it as excel file. Go to File, Download as and Microsoft Excel (.xlxs)

Select the location in your computer to save the file.

Open the excel file.

The responses are of two types, from those who are selfie types and from those who are not. We need to merge those responses.

Go to the cell from where it is to be super-imposed and select paste special.

From the Paste Special check box, Check the box for skip blanks.

The responses will be merged.

Delete the rest of the columns. The excel sheet is ready for coding.