You will definitely need to copy the "group" header info into fields for each row, or else you'll lose that information if you try to sort it.<BR><BR>Are you averse to using/writing a macro?

Launch Microsoft Excel and open the file in which you want to insert VBA code to control cut and paste operations. Click "File" on the Excel ribbon, then "Options" at the bottom of the menu.

Users can even write custom VBA code to meet their programming needs. Using interesting properties like offset, one can operate across different cells in Excel. Operations like selecting the next ...