CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulatransposearray-formulasgoogle-sheets-query
Khan
Khan

Reputation: 97

Transpose multiple rows into column in Google sheet

I want to use transpose formulae in this data

Input

and I want desire output will look like this

enter image description here

Upvotes: 2

Views: 1658

Answers (1)

player0
player0

Reputation: 1

try: 

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

0

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)), " ")), "♥", " "))

0

Upvotes: 4

Related Questions