I can create a macro for you to do this job, such jobs are my daily practice.
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
But first you should specify the source or rules of generating of columns A (is it constant?), columns C:G, J (is it constant?).
Regards!