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

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

Select Unhide Columns from the drop-down menu to reveal all hidden columns within your selection, or select Unhide Rows to do the same for rows.