ImportRange Function to Ignore Empty Gaps between Sheet A and Sheet B-CodePudding

Home > Software engineering > ImportRange Function to Ignore Empty Gaps between Sheet A and Sheet B

ImportRange Function to Ignore Empty Gaps between Sheet A and Sheet B

Time：01-22

How can I combine 2 spreadsheets into one without any gaps? When I import range 2 sheets, there is a gap of ~1000 rows. To make sure there are no gaps between the 2 sheets, I usually create a query "Where Col1 is not null " but I am missing some info. :(

My spreadsheet:

Page link：https//www.codepudding.com/Softwareengineering/679797.html

Prev:Filtering out hierarchical data

Next:Unexpected token. A constructor, method, accessor, or property was expected.ts(1068) Object is possi

Tags：

google-sheets

Links：
CodePudding