Two entries for a single install?

Brief description of your issue

When I run winget list for a specific product I get two entries.

I am unable to uninstall either...

https://github.com/microsoft/winget-cli/discussions/3782

Steps to reproduce

winget list --query "nkdAgility"

Name                         Id                                   Version Source
---------------------------------------------------------------------------------
Azure DevOps Migration Tools nkdAgility.AzureDevOpsMigrationTools 14.0.1  winget
Azure DevOps Migration Tools nkdAgility.AzureDevOpsMigrationTools 14.0.1  winget

Expected behavior

Should see only one intry

Actual behavior

two entries returned

Environment

❯ winget --info
Windows Package Manager v1.6.2771
Copyright (c) Microsoft Corporation. All rights reserved.

Windows: Windows.Desktop v10.0.25967.1010
System Architecture: X64
Package: Microsoft.DesktopAppInstaller v1.21.2771.0

Winget Directories
-----------------------------------------------------------------------------------------------------------------------
Logs                               %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\Diag…
User Settings                      %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\sett…
Portable Links Directory (User)    %LOCALAPPDATA%\Microsoft\WinGet\Links
Portable Links Directory (Machine) C:\Program Files\WinGet\Links
Portable Package Root (User)       %LOCALAPPDATA%\Microsoft\WinGet\Packages
Portable Package Root              C:\Program Files\WinGet\Packages
Portable Package Root (x86)        C:\Program Files (x86)\WinGet\Packages
Installer Downloads                %USERPROFILE%\Downloads

Links
---------------------------------------------------------------------------
Privacy Statement   https://aka.ms/winget-privacy
License Agreement   https://aka.ms/winget-license
Third Party Notices https://aka.ms/winget-3rdPartyNotice
Homepage            https://aka.ms/winget
Windows Store Terms https://www.microsoft.com/en-us/storedocs/terms-of-sale

Admin Setting                             State
--------------------------------------------------
LocalManifestFiles                        Enabled
BypassCertificatePinningForMicrosoftStore Disabled
InstallerHashOverride                     Disabled
LocalArchiveMalwareScanOverride           Enabled

Reproduce the duplicate results with winget list --query "nkdAgility" using the environment details in the issue, then investigate the list and uninstall behavior. Done means the product appears once and can be uninstalled successfully.