Trying to Get Rid of White Space in SSRS Report
I have a Report where I need to Hide Duplicates but unfortunately I now have white space in the Returned Data where the Duplicate Records used to be.  

How do I remedy this so my Report doesn't look so unprofessional?  

I have searched the internet and found answers for hiding rows where there is no data, but in my report there is data that I don't want to show. I would just take it out of the Query but the way the Tables are set up that is not an option.
Trying to Get Rid of White Space in SSRS Report
===

I have a Report where I need to Hide Duplicates but unfortunately I now have white space in the Returned Data where the Duplicate Records used to be.  

How do I remedy this so my Report doesn't look so unprofessional?  

I have searched the internet and found answers for hiding rows where there is no data, but in my report there is data that I don't want to show. I would just take it out of the Query but the way the Tables are set up that is not an option.