I need to run an AdHoc Report... Showing Client, Position and candidates submitted...

I need to run an AdHoc Report... Showing Client, Position and candidates submitted...

Can this be done. I tried to export the candidate list and it only shows "Submitted"... but not to which position.  I can export the job list for all the clients though. If the position they were submitted for was pulled in the candidate export then
I could do a vlookup on the client/job export.
 
I have to send off an email to my client to get feedback on all candidates that were submitted to them on all positions. How can I easily pull this?