Splitting a Cell based on "/" and adding new Rows based on Part Number Logic

Dear Excel Users,

I have a situation where I have some Part Numbers mentioned in Column A separated by "/".

However I want only 1 Part number in 1 cell, and I want the remaining Part Numbers to be copied down to the below row with all the other details in Column B Through M remaining same.

However there are some details that need to be addressed while copying down. (Mentioned in Cell A25 of Attached Sheet)

Please see attached sheet for understanding.

I have 1000 such rows.

Help Appreciated.