How can I import data using query and group it by row values?

Question

I have a table with data which is structured like this: table1

Is it possible to transform my table to table like this using query? table2

Where is your trying code? Atleast please try again something and ask if any problem occur. — Anand Pandey, Nov 20 '17 at 13:11

score 0 · Answer 1 · answered Nov 20 '17 at 13:12

0

=QUERY(A1:C5,"Select max(C) group by B pivot A")

Or

=QUERY(A1:C5,"Select B, max(C) group by B pivot A")

answered Nov 20 '17 at 13:12

TheMaster

score 0 · Accepted Answer · answered Nov 20 '17 at 16:19

0

If there is a possibility of repeated weights, would need to do something like this

=ArrayFormula(query({row(A2:C5),A2:C5},"select Col3,max(Col4) group by Col1,Col3 pivot Col2"))

answered Nov 20 '17 at 16:19

Tom Sharpe

Yeah, weights could have its unique heights. Thank you. – Vidmat Nov 21 '17 at 08:10

2 Answers2