You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

By holding down the Ctrl key, you can copy a Word table's row or column to create a new row or column.

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? Even ...