When creating the ODS Excel file I want to be able to "group" columns in the excel file and have the user be able to use the Excel function to expand/collapse the columns to show the grouped columns or not.   Example data All data exists in the dataset and not calculated within the proc report.   Market             Jan          Feb     Mar       Q1    Apr ........     Q4    YTD A                      10            10        10        30      10               30    120 B                      10            10        10        30      10               30    120 C                      10            10        10        30      10               30    120   When the excel file is opened their is an "outline" created for the grouped data. If the user clicks on the [-] above the columns, the month columns for Jan Feb Mar Apr ....  will "auto hide" and only the Quarterly columns (Q1, Q2 ...) will show. The user can then also clock the plus above the columns to redisplay the months ... View more