Dec 14 2021 06:34 PM - edited Dec 14 2021 06:35 PM
To automate anki flashcard
Have a list of image file names in 1 column.
I will enter captions for each image file, but some have multiple images & no captions.
1 row exported = 1 flashcard.
Filenames to go in Image columns
e.g. 3 images no captions, 4th image has caption. Formula for: if caption in a row, Fill image names up to the image3 column.
Keep pulling from list until exhausted
Image List | Image 1 | Caption 1 | Img2 | Cap2 | Img3 | Cap3 | etc |
001.png | |||||||
002.png | |||||||
etc | |||||||
the answer:
=LET(a,$C$1:$Z$12,b,INDEX(a,1,),c,COLUMN(B1),d,COLUMNS(a)/2,e,SEQUENCE(d,,,2),f,INDEX(a,c,e),g,INDEX(a,c,e+1),h,LEN(g)>2,i,IF(OR(h),f,""),i)
"filled to the right. To see how it works replace the last name i with earlier names."
^ what is the meaning, earlier names?..
which cell do I put formula in
what is the error it's throwing?
Srry would upload a template but there's no option?