Get-SharePointListItems

Get-SharePointListItems.ps1

$SiteUrl = "https//mysite.com/sites/my/site"
$ListName = "List Name"
$Cred = Get-Credential

Connect-PnPOnline –Url $SiteUrl –Credentials $Cred

$Fields = Get-PnPField -List $ListName

$ListItems = Get-PnpListItem -List $ListName -Fields $Fields.InternalName | ForEach-Object {
    $ListItem = $_
    $PSObj = New-Object PSObject

    $Fields | ForEach-Object {
        $FieldTitle = $_.Title
        $TargetFieldTitle = $FieldTitle
        $FieldTitleSuffix = 0

        while (@($PSObj | Get-Member -MemberType NoteProperty | Select-Object -ExpandProperty Name) -contains $TargetFieldTitle) {
            $FieldTitleSuffix++
            $TargetFieldTitle = "$FieldTitle ($FieldTitleSuffix)"
        }

        $FieldTitle = $TargetFieldTitle

        $PSObj | Add-Member NoteProperty $FieldTitle $ListItem[$_.InternalName]
    }

    Write-Output $PSObj
}

#Do stuff with ListItems array