79455042

Date: 2025-02-20 15:44:29
Score: 1.5
Natty:
Report link

Alternatively you can apply this formula if PIVOTBY is available.

=DROP(PIVOTBY(SCAN(0,SEQUENCE(ROWS(A3:A30)),
LAMBDA(ini,arr,SUM(N(INDEX(A3:A30,1):INDEX(A3:A30,arr)
=INDEX(A3:A30,arr))))),A3:A30,B3:B30,SINGLE,,0,,0),,1)

pivotby

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user22566114