Help with SQL Query

I have a table of data that has the following columns

[Id, DateCreated, FileName, AverageImageHash, CropResistantImageHash, ImageWidth, ImageHeight, Notes, Source]

Right now there are duplicates inside of the FileName column and there should not be so I need to get a query written were if there are multiple rows with the same file name all but one of them are deleted. Also I need to add the source from all of rows to the one row that is staying

Example
FileName, Source
aioshf.jpg, hello
oisdhg.png, good
aioshf.jpg, bye
aioshf.jpg, dog

This should turn into the following
FileName, Source
aioshf.jgp, ['hello', 'bye', 'dog']
oisdhg.png, ['good']