Hi guys,
I have previously used a code that was transforming data from the "original" to "new version" as per attached.
However, now the input (i.e. "new original") changed a bit and so I need to change the output ("new newversion").
Please note the code (within old original) and the desired look can be found attached (new newsheet) .
Just to add, I am trying to:
- change the code to fit the new data (new original) into new cell range (new newversion) as per the given example in new newversion.
- additionally split the column "F" and "V" from "new original" into distinct rows within the respective columns of new newversion.
- fix the split of AA - this should be done per [xx] on each separate line.
Please note that the column U of original uses the key from the sheet "key" to achieve the desired split.
- the next record should be pasted into next available row.
Many thanks for your help! It is really appreciated.
Bookmarks