Adding blank rows in an excel

Hi,

FYI, another approach:

dt = dt.AsEnumerable.GroupBy(Function(r) r("Ranking").ToString).SelectMany(Function(g) g.Concat({dt.NewRow})).CopyToDataTable

Sample
Sample20240202-2.zip (8.6 KB)

Regards,

4 Likes