Guest User

Untitled

a guest
Feb 18th, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  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"), )))), "♥ "))}
Add Comment
Please, Sign In to add comment