MySQL does not provide a built-in way to create pivot queries. However, these can be created using prepared statements.
Assume the table tbl_values:
IdNameGroupValue1PeteA102PeteB203JohnA10
Request: Create a query that shows the sum of Value for each Name; the Group must be column header and Name...
