I currently have a response form where people are submitting requests for different items. Not every item is requested every time. The end goal is to automatically have them receive an email with a list of each item they requested after submitting the form.
=rangetoverticaltable from Form Mule, a Google Sheets add-on, you get a pretty table as below
The end goal is to get the same table returned but with the "water" column being filtered out as it is blank, i.e.:
I've read this post multiple times and I can't seem to figure out if the answer at the end of the post closes with it isn't possible or I'm missing a step.
I am currently using the formula
and this generates the first table as shown.
What can I add into the filter() section to remove the rows that have empty cells in column B?
The link to the google sheet is here.