imagegoogle-sheetsrowflatten

Converting Rows of data into a single column, including IMAGES

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

Data set

Desired result

Solution

  • You may try:

    =let(Σ,B5:E7, reduce(tocol(,1),sequence(rows(Σ)),lambda(a,c,vstack(a,tocol(chooserows(Σ,c),1),))))

    enter image description here