Hi community,
Was hoping if someone can please assist with this. I have lots of tabs in 10 spreadsheets which I am importing however, the column headers needs to be adjusted as they are inconsistent in the tabs. I need the headers to be as per screenshot highlighted in yellow. The currency (USD) header is not required.
Please note all the tabs/sheets are of same structure so, solution for one sheet should fit all.
Can someone please assist me in solving this problem?
Thanks as always,
Packaged Workflow and screenshot attached.
