remove blank rows

Hello, I am using Google Sheets for this project. I am wondering if there is a way to condense data without deleting rows. In my example below I have the dataset being collected by a Google Form. In cell A9 I have a formula to grab values out of the data set and transpose them. I am wondering...

Hi Folks. I'm working on automating a solution to a problem file and I need to extract some rows to a new sheet programmatically. Specifically I'm looking for a way to loop through column H and any cells that begin with the word 'Net' (spelled exactly like that) need to be cut out and moved to...

Hello all, I am using this formula to pull a list of survey comments for employees from a raw data sheet. It is working fine but Id like to not have all the blank results in between the ones that have comments. Any Suggestion on how to alter this to no include the blanks...

I have a set of data (A1:H658). In column A, I want to put an "X" next to any rows that I want to pull over. My traditional way of doing this is to do an IF statement that says IF(A1="X",B1,""). But this returns a lot of blanks. For example, if I have ~500 rows of data, and I put an "X" next to...

Hi, I have the existing VBA code (see below) to create a CSV file from a excel sheet and this work well, however the problem is the software that reads the CSV file does not like data missing in rows or enire blank rows. Therefore I need a macro that would amend the new CSV file as it is been...