title: how to get rid of empty cells while doing column grouping in SSRS report
body: <p>I have added a column group in my report, which should work as below.</p>
  
  <p>group1 group2 group3<br>
  data1  data1  data1</p>
  
  <p>But my results page looks like this</p>
  
  <p>group1  group2  group3<br>
  data1    null   null<br>
  null    data1 null<br>
          null  null  data1</p>
  
  <p>how do i get rid of nulls or empty spaces above?
  please help me how do i fix this issue.
  FYI, data1 is not a single column. under each column group, i have 7,8 columns that needs to show/repeat for each column group.</p>
  
  <p>Appreciate your help.</p>
  
  <p>Thank you.</p>