Hello,
I have read your requirements and i understand what you want to do.
I have also check your attachment excel fiiles.
I have experienced working with excel data, csv, text data, json. I can solve your problem via python programming.
If you interested to hire me than i can send demo output of your probmles.
i waiting for you reply.
Thanks