I managed to get the information I needed using Powershell. Having connected Powershell to Exchange Online I ran the following command;
Get-DistributionGroup -Filter * | Select Name, ManagedBy | Export-CSV C:\export.csv -NoTypeInformation
Get-DistributionGroup -Filter * | Select Name, ManagedBy | Export-CSV C:\export.csv -NoTypeInformation
$UserCredential = Get-Credential2. Enter your Exchange Online credentials
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection4. Run;
Import-PSSession $SessionWhen you are finished run;
Remove-PSSession $Session