We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

how to hide the empty cells/columns for multi level columns


I have  4 levels columns as, Year of Date, Month from the Year, Quarters of year, and then Week. 
and having 3 field values as the sum of Quantity, Sum of the Purchase price, and Sum of the Sales price.
when expands the year, I can see the empty columns under that year. Same for the next levels…Please check the attached image for reference.  
So how to remove those empty columns …


Please login or Register to Submit Answer