Delete empty rows in spreadsheet?

1
votes

I am using VMerge script to merge the data in two sheets of a Google spreadsheet to another sheet. The sample Spreadsheet is here. The merged data is in the sheet named merge. Now how can I remove the blank rows in the merged data. The blank rows comes from the Sheet1 & Sheet2. I have given the full range A1:B in the formula

=VMERGE(ImportRange("0AozvCNI02VmpdG9MNkhIWk8xVWJ0XzVsLVN0aHdVUlE","Sheet1!A1:B");ImportRange("0AozvCNI02VmpdG9MNkhIWk8xVWJ0XzVsLVN0aHdVUlE","Sheet2!A2:B"))

Because extra data is added to sheet1 & sheet2 occasionally.

1
google-sheetsdelete-rowvmerge

1 Answers

4
votes

It is solved using the query as,

=Query(VMERGE((ImportRange("0AozvCNI02VmpdG9MNkhIWk8xVWJ0XzVsLVN0aHdVUlE","Sheet1!A1:B"));ImportRange("0AozvCNI02VmpdG9MNkhIWk8xVWJ0XzVsLVN0aHdVUlE","Sheet2!A2:B")); "select * where Col1 is not null")

See the sample sheet here for reference.