Results 1 to 5 of 5

Reformat data to remove blanks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-28-2009
    Location
    Portland, Maine
    MS-Off Ver
    Excel 2003
    Posts
    102

    Reformat data to remove blanks

    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!
    Attached Files Attached Files
    Last edited by yunesm; 04-21-2011 at 01:58 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1