Is there a way to remove blank lines when combining multiple google sheets?
Blank Lines
Hi Emily,
Hope you’re great!
Just to clarify and better assist you: the blank lines you mentioned, is it in your destination file?
a year later
Karoline from Sheetgo Yes, when combining I only want the lines with data in the destination file vs pulling in all the blanks making the sheet huge.
4 days later
EmilySMassey Hi Emily,
Can I have a screenshot of your data with blank rows, please?
It’s not letting me post a screenshot here. It’s giving me an error. There are 23K lines in the combined data sheet and 18K of them are blank.
EmilySMassey I’ll send you an email ;)