CSV to excel formating

Please check the upload for the source file

Instead of the alerts in column 1, I need to replace it with Location as title and some city name in A2, A3 and all.

And in column2, I wanna check if the text “jobs” present, If yes I need to replace it with 0.

I have been using UI path only for a few days now, so I anybody makes it as template, it would be of great help.