Hello,
This question is related to my other post here: How to spill a second column from the spill formula in one cell? (two-dimensional spill :) ?)
In that example, we were able to output two columns of data with a spill from a single cell. Now suppose that there are multiple spills, one in D1, another say in F1, another in H1, etc.
Is there a way that I can output all spills such that they are vertically concatenated with no spaces in between, so overall they would look like two longer columns of data? I tried a few things with CONCAT, but wasn't successful (and only got concatenated data inside the cell ). The reason I don't want to manually paste them under each other is that their sizes will grow over time as more data is added to the sheet. So it will be really nice to have this longer columns to adapt automatically and get longer over time .
Thanks for any input!
This question is related to my other post here: How to spill a second column from the spill formula in one cell? (two-dimensional spill :) ?)
In that example, we were able to output two columns of data with a spill from a single cell. Now suppose that there are multiple spills, one in D1, another say in F1, another in H1, etc.
Is there a way that I can output all spills such that they are vertically concatenated with no spaces in between, so overall they would look like two longer columns of data? I tried a few things with CONCAT, but wasn't successful (and only got concatenated data inside the cell ). The reason I don't want to manually paste them under each other is that their sizes will grow over time as more data is added to the sheet. So it will be really nice to have this longer columns to adapt automatically and get longer over time .
Thanks for any input!