Dear All,
I would like to export data from excel file to separate files based on the code name (codes are in one of the column). There are around 60 codes.
I would like that extracted data is saved to separate files with code names.
Also, I would like to modify columns in the new file from SUFFIXn to <code + SUFFIXn>, eg. ASUFFIX1
Exemplary input and outpu data is attached.
Help would be appreciated,
Regards,
D.
input.pngoutout.png
Bookmarks