I need to transform a data input from the attached example as per follows and struggle to write a script that would cater for such needs. Please see the attached.
The data shall be copied from "original" and the columns should be split as "transformed" based on the information in the "key" sheet.
The loop should then run row by row and next line shall be inserted into next available row as illustrated on example in attachment.
Many thanks for your guidance!