Advertisement
Doonzu

Untitled

Feb 24th, 2023 (edited)
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =LET(
  2.       c, A2:A24,
  3.       bm, B2:B24,
  4.       uc, UNIQUE(c),
  5.       REDUCE(HSTACK("구분", "브랜드명"), uc, LAMBDA(a,b,
  6.             VSTACK(a, HSTACK(b, TEXTJOIN(" / ", , FILTER(bm, c = b))) )
  7.       ))
  8. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement