Per attached image, the grouped column headers should be moved 1 cell left each, so that they don't overlap with the grouped data (product in col D). I've tried to rectify this and seen some examples of kinda how to achieve this. However why is the default behaviour as shown. My users want to be able to sort etc by the group headers and the one that overlaps with the data can't be sorted etc. It's almost as if this is a bug in the control. I can't think of any good reason why the last group header would be aligned with the first data column when exporting to excel.