MySql pivot table for scatter chart

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

Name  | X   | Y
Run1  | 0.1 | 0.2
Run2  | 0.3 | 0.4

Into the following form that is displayed the way I want in a confluence scatter chart:

Name  | 0.1 | 0.3
Run1  | 0.2 | 
Run2  |     | 0.4

It looks silly I know but this is the only way a scatter chart will diplay x-y data correctly and preserve the label in the first column.