hello @sai3
you can use this linq code here (From coll In DT.Columns.Cast(of DataColumn) Let x=String.Join(",",(from p in DT.AsEnumerable().Select(Function(r) r(coll.ColumnName)).ToArray)) Select DT.DefaultView.ToTable(True,"ColumnName").Clone().Rows.Add(x.ToString.Split("|"c))).ToArray.copytodatatable
this will split your rows and than convert it in to column
Just make sure you put the correct columnName in the code
You already have solution above using split function. The only thing you have to take care is the separator. The comma β,β will not work here as the values inside parenthesis () already have comma.
Use following trick.
Replace β),β with β);β and then use semi colon β;β as separator in Split function.