Excel is showing column1, column2 where we have column number in parent grid < column number in child grids .Want to remove extra columns where data is not present

In hierarchical grid where we have (number of columns in parent) <  (number of columns in child)…