Formula in O17 can be replaced by this formula so that formula in P17 can be avoided. No dragging of formula.
Single entry in O17 is sufficient.Formula:![]()
=LET(Clma,UNIQUE(A17#),clmb,TEXTSPLIT(TEXTJOIN(";",FALSE,BYROW(Clma,LAMBDA(Ro,IF(Ro="","",TEXTJOIN("_",FALSE,BYCOL($B$17:$M$20,LAMBDA(x,SUMIF($A$17:$A$20,Ro,x)))))))),"_",";",FALSE),HSTACK(Clma,clmb))
Bookmarks