Hello,
I have a spreadsheet (attached) that I need to clean-up.
The spreadsheet contains the free text responses from a 14 question survey. If a respondent did not leave a comment there is a blank. For each question this leaves an inconsistent spacing between the respondents.
I have no need to be able to tie back a comment to the specific respondent so to facilitate categorizing and analyzing the data I would like to reformat the data so each question is continuous list of actual responses.
I know how to find empty cells or rows and delete them; however, that doesn't help me here.
The spreadsheet I've attached shows what the data currently looks like (RAW) and what I'm trying to do (FINAL).
Any help is very much appreciated.
Thanks!
Bookmarks