user bryan-p said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/CwRFGzP_2uw)
Using Query() to show updated info
Can I use a Query() to show the most updated info in this sheet? The expected results are right below. If a user submits the form but leaves one of the fields blank, that blank field shouldn't be included - only the most recent responses from Question 1 and 2.
The 3 rows of data as presented in the user's spreadsheet were too few to develop a solution, so I added several more rows as presented in my the following