You have chosen to sponsor your bid up to a maximum amount of .
This is not a manual excel project. I want you to be able to use excel functions or macros if necessary.
This is simply reshaping existing excel file to new ones like adding patterns concatenating with some important texts added, etc.
Only two existing excel files, and I want two output files.
Important:If you can do the whole task using simple functions without relying on macro, that's better.