I would rather not format this drive because it contains a lot of data but I may if desperate enough. I had the same problem with a USB before and had to format it to get it to work.
I only started getting this issue after I connected my USB to another computer which makes me think a virus caused this. Note the drive letter name of USB/ SD card/ pen drive in the drive list. Hello, I have this issue where the files and folders on an external device (such as an external HDD and USB) are not showing up, yet the device is visible.