Could I customize my headers?

[ericzou83]

Is there any function can let me customize my headers in loadHeaderRow stage?

Ex, My table is like below

If I use loadHeaderRow(2) in this case, it will cause error because AAA, BBB and CCC are duplicated twice.
Even if Ignoring the duplicated issue, the combine cells of header1 and header2 will get empty because the value of combined cells are stored to the left-top cell (aka, A1 and B1) so the values of A2 and B2 will be empty.

But if there is a function can let me customize my headers like customizeHeader(2, ['header1', 'header2', 'category1.AAA', 'category1.BBB', 'category1.CCC', 'category2.AAA', 'category2.BBB', 'category2.CCC']), that I can avoid the issue above.

PS. the function I want is not setHeaderRow I don't need to write customized header to online google sheet, I just want to use my customized headers to parse the data which I just dump from online google sheet to my local computer memory.