To return your columns to their original states, or to leave certain data visible when you collapse other groups, you can use Excel's Ungroup ... Q4 remain visible. To remove all column (and ...

Step 1: Highlight the group of cells that contains the duplicate values you'd like to delete. Excel will then scan the selected columns for duplicates and remove them. When it's done, a dialog box ...