Separate Grouped and Ungrouped rows in excel

[ppr (Peter Preuss)]

Also mentioned the requirements / handling seperator rows were asked. Please avoid ping pongs by letting answer unanswered. Thanks for Support.

Also have alook here:

Returning the difference between two data tables

@jamills Question… for the assign would it be: (some int32 variable) = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).ToList().Count()? Yes, give a try as it is a quick approach Except is looking on dt2 rows that are not present in dt1 and in this statement will return the count of this evaluation.