daily pastebin goal
38%
SHARE
TWEET

Untitled

a guest Feb 18th, 2019 94 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. A   B
  2. 1 a   x
  3. 2 a   y
  4. 3 a   z
  5. 4 b   i
  6. 5 b   h
  7. 6 b   w
  8.    
  9. A   B   C   D
  10. 1 a   x   y   z
  11. 2 b   i   h   w
  12.    
  13. ={UNIQUE(FILTER(A1:A, A1:A<>"")),
  14.   ARRAYFORMULA(SPLIT(TRANSPOSE(
  15.   QUERY(TRANSPOSE(IF(TRANSPOSE(
  16.   QUERY(TRANSPOSE(
  17.   QUERY({A1:B}, "select count(Col1)
  18.                  where Col1 !=''
  19.                  group by Col1
  20.                  pivot Col2", 0)),
  21.                 "select Col2, Col3", 0))>=1,
  22.   QUERY({A1:B}, "select count(Col1)
  23.                  where Col1 !=''
  24.                  group by Col1
  25.                  pivot Col2
  26.                  limit 0"), ))&"♥", ,
  27.   COLUMNS(IF(TRANSPOSE(
  28.   QUERY(TRANSPOSE(
  29.   QUERY({A1:B}, "select count(Col1)
  30.                  where Col1 !=''
  31.                  group by Col1
  32.                  pivot Col2", 0)),
  33.                 "select Col2, Col3", 0))>=1,
  34.   QUERY({A1:B}, "select count(Col1)
  35.                  where Col1 !=''
  36.                  group by Col1
  37.                  pivot Col2
  38.                  limit 0"), )))), "♥ "))}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top