This can be done with the OFFSET function, adding one extra empty row to the bottom of the source range, and checking the “Sort entries ascending” checkbox to move the blank entry to the first position. Are there other ways? Is there some other way to combine data with an empty string dynamically?
~ doesn’t work.
