님의 두 식을 합쳤습니다..

=LET(
ttxt, LET(Area, Sheet1!A2:INDEX(Sheet1!A:A,1+COUNTA(Sheet1!A:A)),
txt, FILTER(Area, Area<>""),
num, --TEXTBEFORE(txt,"("),
date, TEXTBEFORE(TEXTAFTER(txt,"("),")"),
valid, num<>1,
grp, SCAN(0, valid, LAMBDA(a,b, IF(b, a, a+1))),
uGrp, UNIQUE(FILTER(grp, valid)),
MAP(uGrp, LAMBDA(g,
LET(
idx, FILTER(SEQUENCE(ROWS(num)), (grp=g)*(valid)),
d, INDEX(date, idx),
ROWS(idx) & "개 (" & INDEX(d,1) & "~" & INDEX(d,ROWS(d)) & ")"
)))),

num, --TEXTBEFORE(ttxt,"개"),
sDate, TEXTBEFORE(TEXTAFTER(ttxt,"("),"~"),
eDate, TEXTBEFORE(TEXTAFTER(ttxt,"~"),")"),
valid, num<>1,
grp, SCAN(0, valid, LAMBDA(a,b, IF(b, a, a+1))),
uGrp, UNIQUE(FILTER(grp, valid)),
MAP(uGrp, LAMBDA(g,
LET(
idx, FILTER(SEQUENCE(ROWS(num)), (grp=g)*(valid)),
ROWS(idx) & "개 (" & INDEX(sDate, INDEX(idx,1)) & "~" & INDEX(eDate, INDEX(idx,ROWS(idx))) & ")"
))))

​결과 잘 나옴..

​