MySql pivot table for scatter chart [on hold]

I would like to transform the following sql (e.g. select Name,X,Y from mytable) result:

Name  | X   | Y
bla1  | 0.1 | 0.2
bla2  | 0.3 | 0.4

Into the following form that is displayed correctly in an Excel scatter chart (i.e. with each row as a series and each name as a label):

Name  | 0.1 | 0.3
bla1  | 0.2 | 
bla2  |     | 0.4

This is the only way a scatter chart will display x-y data correctly without fiddling with chart settings: