Datatabel Rows to Column

Question

i dont use sql pivot

sql query return

 

date                  total        name

01/01/2014         20        mark

10/01/2014        30        daniel

11/01/2014        40        mark

i want to datatable

date                       mark     daniel

01/01/2014           20

10/01/2014                          30

11/01/2014           40