c# - Append multiple column values into single column by adding column values below in datatable -

am having datattable below 3 columns name,favourite1 , 2.

name   favourite1   favourite2  xxx     eating       cricket yyy     books        music 

my expected output is

name   favourites       xxx    eating         yyy    books          xxx    cricket yyy    music 

how make ... :(

use code in c#. merge function used merge 2 data tables. expected output in fav1 datatable.

datatable fav1; fav1= threecolumntable.copy(); fav1.columns.remove("favourite2"); fav1.columns[1].columnname = "favourites";  datatable fav2; fav2= threecolumntable.copy(); fav2.columns.remove("favourite1"); fav2.columns[1].columnname = "favourites";  fav1.merge(fav2);