As stated by the title, I have various rows which do not contain equal amounts of data. Furthermore, the size of each row changes per user input on another sheet. I want to combine all these rows into a single row or column without gaps (doesn't matter which). The order does not matter. I need something very efficient as I have 200 rows.

This handy formula retrieves the data from an entire sheet. "code_f3" is the name of the sheet whence the data is retrieved. I applied FLATTEN to it, and it did what I wanted except for filter out the blanks. How can I get rid of the blanks?


1 Answer 1


You could try something as simple as =tocol(code_f3!A1:ZZZ,1) to put all the results (minus blanks) into a single column. ZZZ is the maximum number of columns Google Sheets allows (18278).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.