insert row where unique identifier has mutliple columns

All
In desperate need of assistance - else need to do manually....

I have a data set where some information is across several columns for the same record.....Please see attached

I need a script etc to insert a row where there is data in coulmn j-m for a record and replicate coulmns a-g in the new row and move data from columns j-k and then do the same if data in l-m.... at the end of the script - remove coulmns j-m
ExcelForumExample_1.xlsx

hard to explain but you can see example in attachment...

TIA

Shaz

Thank you so much

with some jiglling on columns numbers etc I got it to work on my larger dataset...

Saved me hours of work...

rgds

Shaz