I have found many solutions that pull rows of data into a single column of data, but I cannot figure out a solution that will also return images as part of the data.
Sample data is here: https://docs.google.com/spreadsheets/d/1q4qRgXSq6xXhddArPCoBIuOOupRvokUd0andADCNN0Q/edit?usp=sharing
>Solution :
You may try:
Here’s one approach you may test out:
=let(Σ,B5:E7, reduce(tocol(,1),sequence(rows(Σ)),lambda(a,c,vstack(a,tocol(chooserows(Σ,c),1),))))
