Unfortunately, the solution to this is going to be pretty manual. If you can't edit the data in the database (which is what I'd recommend when you have data hygiene issues to this extent) you can at least fake it with groups.
For instance, in your Independent-Expenditures data source, you have three values for the candidate Dan Lungren: LUNGREN, DAN ; LUNGREN, DANIEL, and LUNGREN, DANIEL E.Use the grouping feature to group all three of these values together, and then right-click on the new value (which will look like all three names concatenated together) and then select "Edit Alias," and rename the alias LUNGREN, DAN, or whatever it is in the 2010 US House & Senate data source. Then edit your data relationships to have the linking field be between the "Candidate Names capitalized" field in your primary source and the "Candidate name (group)" field in your secondary source. (If you're not entirely sure what I'm talking about, check out this link: Blend Your Data . Scroll down to where it says, "Step 4: (Optional) Define or Edit Relationships")
The fastest way to do this is with a dashboard and a wildcard filter, I'd say. I've set one up for you in the attached workbook - type the last name of a Winning Candidate in the text box at the top (capital letters), hit enter, then see what comes up in the Sheet 8 below. Group together the appropriate values, and then edit the alias to match what it is in the primary data source.
If this resolves your issue, please mark this question as answered.
Support_OppositionV3.twbx 3.1 MB
Thank you so much for your help! I do see what you mean and I was afraid of the manual process. This is actually governmental data from the fec.gov website so any modifications would have to be done within Excel. I have figured out another way with different concepts and maybe you could take a look at that for me. Here is the link: Setting Measures to Another
I am going to mark this questions is answered - thanks again!