https://support.google.com/docs/thread/302966799/how-to-find-all-instances-of-a-text-string-and-sum-the-adjacent-numbers?hl=en Oct 20, 2024 ... ... (c,index(ifna(xmatch("?*",to_text(c),2,-1)))))),columns(d)),lambda(r,scan(,r,lambda(a,c,if(c="",a,c)))))),. unpivot_, lambda(data ...