Is there a way to programmatically Ungroup rows that have been grouped?
Yes. Grouping is tightly tied to sorting. You group and ungroup a column using the SortedColumn.Add or Remove method respectively.
Thanks Mike works perfectly!