Transpose multiple rows into column in Google sheet

Question

I want to use transpose formulae in this data

and I want desire output will look like this

Answer 1

try:

=QUERY(A2:B, "select max(B) where A is not null group by B pivot A")

---

or:

=ARRAYFORMULA(SUBSTITUTE(TRANSPOSE(SPLIT(TRANSPOSE(QUERY(QUERY(
 {SUBSTITUTE(A2:A, " ", "♥"), B2:B}, 
 "select max(Col2)
  where Col1 is not null
  group by Col2
  pivot Col1"),,999^99)), " ")), "♥", " "))