Report with Scout and Parents' email addresses

We have a need to create reports with the roster of scouts (by rank / den) and the associated parents’ email addresses in line so we can use those addresses externally to TT. For example something like:

SCOUT NAME PATROL FATHER’S EMAIL MOTHER’S EMAIL
Scout 1 Den 1 xxx@email.com yyy@email.com

Right now I can only find a way to report scouts and parents in seperate rows. Also the parents are not assigned to dens so there is no way to sort and extract this info. Also we do not put emails on the scout records so all communications always go to parents.

Thanks for the help.