How to delete duplicate records?


I've been struggling with this problem and hopefully someone could point me in the right direction.

I have a table like so:
Each row represents a user who has a mobile device with an install game.
Row 1 says that user 1 has device abc and with game 1 installed on it.
The same user has game 2 installed on the same device (as seen by row 2)

What I need to do is to identify all the duplicate and to delete them so that at the end,
any device that…

How to delete duplicate records?

What does it mean to delete a file that’s “shared with me” in Google Drive?

I don’t use Google Drive very much, but I noticed I had a couple of files in the “shared with me” section of the Google Drive web app. So I decided to remove them from view, and the only way to do that is to delete them, one by one.

Removed one file.

One removed file is still accessible by collaborators.

I don’t own any of these files. They were shared with me. So what exactly did I just remove then? I can’t possibly remove things that I don’t own? I assume that the last notification indicates that the owner can still access his own file… duh! But the question still remains, what is it that I’m removing then? Removing myself from the access list of a file I didn’t own in the first place?…

Interestingly, most of these files were things like PDF files and shared Google Maps locations, things that were shared publicly, links to which I must have clicked on at some point on different websites. So I was never really “collaborating” with any of these people, the owners of these files, so they never shared the links to these files with me directly and I was never on any kind of access list.

Cannot move (or delete) Groove Music icon in Windows 10

On my new Windows 10 (v1803) PC there are a bunch of strange pre-installed applications, like Groove Music. These clutter up the Start Menu with no hierarchy, just all on the same level. I’d like to put these icons into a separate folder on the Start Menu.

Groove Music icon creating clutter

Searching online I’ve found several articles describing how you can (attempt to) uninstall these Windows Store applications, but nothing about how to move or remove the icon. I’m not (yet!) looking to uninstall the app, just to organise the Start Menu into a more logical heirarchy.

In previous versions of Windows, a user could create a folder called (say) Windows Stuff in the appropriate path. Then you could drag the icons into this folder. After acknowledging the UAC prompt the icon has moved. Great! With these new Windows 10 application, however, I can’t seem to do anything with them.

Things I have tried:

  • Navigated to C:\ProgramData\Microsoft\Windows\Start Menu\Programs. No icons or .lnk files for these Windows metro apps are visible.
  • Navigated to C:\Users\[ME]\AppData\Roaming\Microsoft\Windows\Start Menu\Programs. Likewise, none of these metro apps appear.
  • Used WIN+R and then shell:AppsFolder to actually view installed applications. Here I can see the ZuneMusic application (see below), but I can neither delete, uninstall or move it.

ZuneMusic application

  • Tried grabbing the icon directly in the Start Menu and dragging it…but a No Entry symbol appears and the icon cannot be moved or removed.

How do you get control over the Start Menu in Windows 10 (in a similar way to Windows 7 or Windows XP)?