Forum Discussion
Regrouping Data in single row
Hi Everyone, I've been struggling with an issue and can't find the answer using an AI excel chatbot... So sorry if this thread has already been addressed but I find it quite hard to formulate. Fi...
You may try PIVOTBY() as well.
=PIVOTBY(CHOOSECOLS(A2:D13,3,1,4),MAP(A2:A13,B2:B13,C2:C13,LAMBDA(a,b,c,"Costume "&SUM(N((A2:a=a)*(C2:c=c))))),B2:B13,SINGLE,0,0,,0)