Forum Discussion
PivotBy or GroupBy
Dear Experts, Quick question, I have a data like this from Column A~F, and want to make a data like in Col J~L So, I want a summary , that for the slot0 && txnum==1, wh...
PIVOTBY() should work. Try-
=PIVOTBY(Table1[slot],Table1[txNumber],Table1[numOfPrb],LAMBDA(x,ARRAYTOTEXT(UNIQUE(x))),0,0,,0)And using FILTER() function.
=IFERROR(ARRAYTOTEXT(UNIQUE(FILTER(Table1[numOfPrb],(Table1[slot]=$L3)*(Table1[txNumber]=M$2)))),"")