Need Help | Tidy up inconsistent column headers

[udles5666]

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. 

[RSreeSurya · Accepted solution]

Hi @udles5666 ,

Attaching the workflow. 

Hope this works.