0

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?

=FLATTEN(ArrayFormula(
  INDIRECT(
    "code_f3!"
    &ADDRESS(1,1,,TRUE)
    &":"
    &ADDRESS(ROWS(code_f3!A:A),COLUMNS(code_f3!1:1),,TRUE)
    ,
    TRUE
  )
))

1 Answer 1

2

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 you have read our privacy policy.

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