gsheets script to normalize fields

Job ID: 34798891

Budget: $10 – $30 CAD

- Gsheet contains rows of data in groups
- Each row-group has a heading row
- Some of the columns match, but not all of them

What I need is a script that normalizes the columns so that there is only one header row at the top for all the rows in the sheet.

The script has to work for any combination of columns and rows

See attached sample
Related categories: Scripting Google Sheets