Complex Header Name

SH_94

Dear Community, 

I would like to seek for help if anyone know how to convert the original data header to the result as per screenshot below:

The challenging part is i need to combine different row header as one and also need to remove ( ) symbol starting from column I before combining it. 

Output

I have also attached the excel file below for your reference.

Many thanks again in advance

Excel One.xlsx

atcodedog05

Hi @SH_94 

Here is how you can do it. The workflow is dependent on row number of header hence adjust row header number as required in the select record tool (highlighted below). Let me know if you face any issues.

Workflow:

Hope this helps : )

Complex Headers.yxmd

Excel One.xlsx