+ Reply to Thread
Results 1 to 3 of 3

Sorting data to find partially empty rows

  1. #1
    Registered User
    Join Date
    10-17-2017
    Location
    United States
    MS-Off Ver
    1708
    Posts
    1

    Sorting data to find partially empty rows

    Hi,

    I recently conducted a survey using Qualtrics that had one section with socio-demographic questions and a main section that had 10 different versions of the survey and one of those was randomly sent to each participant for that section. Some participants only filled out the socio-demographic section and not the main section. I want to get rid of these responses because I only want responses that actually filled out the main survey section. How do I filter the data so that I can delete the responses that didn't fill out any of the 10 surveys? Here is a visual of some of the survey data if it helps. Each row is one response. Each column is labeled as Survey.Question.Answer so 3.5_1 is Random Survey 3.Question 5. 1st Answer Choice. If I need to give more info please let me know. Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Sorting data to find partially empty rows

    Try using Advanced Filter or PowerQuery if you have access to it.

    See link for detail on Advanced Filter (Also read related links found at bottom of page)
    http://www.contextures.com/exceladvancedfiltervba.html

    For PowerQuery, you'd convert the data range to Excel Table then load to PQ.
    In the editor, click on down arrow on one of the column you want to filter for.

    Then go to Advanced options. There you can add multiple columns as condition for filtering.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sorting data to find partially empty rows

    Hello and welcome to the forum.

    I would create a column to the far right of the data with a formula that shows which cells to delete. You can use COUNTA to show the number of cells in each row that have text in them. If that number is 0, delete that row.

    If you post your workbook (or a small sample of it) we will be able to help you further with a more detailed explanation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting whole sheet simultaneously but respecting empty rows
    By 02sm5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2016, 05:57 PM
  2. Replies: 3
    Last Post: 07-10-2014, 08:11 PM
  3. Auto sorting/filtering data without empty rows to generate scatter plots
    By turkeyusa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2014, 02:05 PM
  4. Find empty rows in a database
    By imran91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2012, 05:25 AM
  5. find empty row and next 3 rows
    By boeffie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2010, 08:00 AM
  6. [SOLVED] How to find next value if rows between are empty?
    By joes in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 11:30 AM
  7. Find last row of data and delete empty rows
    By Pat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

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