I recommend looking into Python with Pandas, they will give you all the flexibility you need plus they are very easy to learn. You will most likely have to reach out to them regardless. If you are good with excel, you will find pandas to be like a missing superpower.

Otherwise if you rather not deal with code or are in a rush, have a look at other pre-built solutions besides Talend ETL. My go to is https://skyvia.com , super easy to get started and automate your workflow. I think they offer a free trial. There are many others that I have not tested but either way you should be able to get the results you need.