Sort by any global field in the table (make one if not exist), then when export, group by the global and select export field "summary by global".
Well, you learn something every day. I didn't know you could do this.
"Sort by a global field."
But it works exactly as described.