How to repeat a image from IMAGE formula for N times by rows in google sheets

Question

I want to repeat a qr code generated from web by for n times

when I enter 3 in C2 i need to get 3 barcodes in D2:D4 as shown in the above image

sheet link

Answer 1

try:

=INDEX(IMAGE(QUERY(FLATTEN(SPLIT(REPT(
 "https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&
 ENCODEURL(A2)&"​", C2), "​")), "where Col1 is not null", )))