Consolidating lines in a union report table

Content

I have a union report below, in one of the unions I have req data and the last column is SUM(0)

In the other union I have all columns with the statement of '' except for the ID column, which reports the same value that I have in the first union, the last column reports prospects, which works good. 

If I only show the number of prospects the ID will consolidate and sum to 2 - works good. 

I need to be able to add in the other variables so the lines will collapse and show me the correct count of prospects for each ID.  I know the '' is throwing off the line but I don't know what to do to get it to consolidate with the first union.   Thoughts?