How can I change the format of the excel which is being exported from the datatable?

pinquan

I would like to change the format of the excel. Instead of exporting it like a datatable(refer to Fig 1), I would like to export like so.(refer to Fig 2)

Fig 1.



.
.
.

Fig 2.



-------------



.
.
.