Automate moving and renaming files

I have files nested within multiple sub-folders. I want to move these files, one folder up the folder structure and rename the files as per its new parent folder. I will need this to be automated with a script.

Example logic

  1. Find Root folder
  2. Get contents of Subfolder of Subfolder files.
  3. Move files to its Parent folder (aka ‘Attachments’ folder)
  4. Rename files to with its current Parent folder name.
  5. Delete empty Subfolder
  6. Loop above action of Root folder folders until complete.

Example folder structure

enter image description here

Desired Result

enter image description here

I’m assuming this may require to Automate with a script but I have no idea how to do it. Can anyone help me?