로우 데이터 정리 목적 함수 문제 관련....

@건빵맛별사탕 님 첨부 참조 (version: M365)

이름 설정
data =문제1!$A$4:$E$28
list =문제2!$B$3:$F$25

셀 수식
문제1
J4 =SORT(UNIQUE(FILTER(INDEX(data,,2),INDEX(data,,1)=$I$4)))
K4 =TRANSPOSE(FILTER(INDEX(data,,5),(INDEX(data,,1)=$I$4)*(INDEX(data,,2)=$J4)))

문제2
H2 =LET(uMission,SORT(UNIQUE(INDEX(list,,1))),
tier,TRANSPOSE(SORT(UNIQUE(INDEX(list,,5)))),
rMission,ROUND(SUMIFS(INDEX(list,,4),INDEX(list,,1),uMission,INDEX(list,,5),tier)/SUMIFS(INDEX(list,,4),INDEX(list,,5),tier),5),
tTier,BYCOL(rMission,LAMBDA(c,SUM(c))),
top,HSTACK("미션",tier),
mid,HSTACK(uMission,rMission),bot,HSTACK("Total",tTier),
VSTACK(top,mid,bot))

N2 =LET(uMission,SORT(UNIQUE(INDEX(list,,1))),
tier,TRANSPOSE(SORT(UNIQUE(INDEX(list,,5)))),
tMission,SUMIFS(INDEX(list,,4),INDEX(list,,1),uMission,INDEX(list,,5),tier),
tTier,BYCOL(tMission,LAMBDA(c,SUM(c))),
top,HSTACK("미션",tier),
mid,HSTACK(uMission,tMission),bot,HSTACK("Total",tTier),
VSTACK(top,mid,bot))

첨부파일 : 데이터-필터링.xlsx