DataTable

Question

hello.Below I showed datatable.Which I get from sql.I need to add second row <Name > value to first  NULL row and remove second row programmatically.

So, they are same rows.Only name and surname showed on different rows.I need join them in one row.Help please.

           ID   |  NAME | SURNAME |

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

            1   |  null   |    MIKE          

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

            1   |  JON     |   null

          

            Thanks in advance