You have a collection, but only some of the items need a Collection Page. The others are largely blank because those items don't have the content you want. Your goal is to;
Here's an easily implemented solution, which I've built a cloneable to demonstrate.
Basically you add a special field to your Collection, and a few tweaks to your Collection Pages so that search engines won't index the blank ones.
I recommend this approach if MOST OF your pages are used, and only a few of them need to be suppressed.
Separate out your "special" content into a separate collection.
For example, you might have a table of employees, some of whom also perform a recruiting function, and have a bio page for contacting them.
Here you could have two collections, C1 and C2.
Set it up so that C1 has all of the general employee information, and C2 has the recruiter-specific information. Add a single-ref link from C1 to C2.
This makes it easy to;
One small downside here is that because C2 pages need to be able to display on their own, they may need some duplicate content ( like the team member's name ) with C1.
I recommend this approach when only a few of the C1 items need a page.