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
Solved! Go to Solution.
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 : )
Happy to help : ) @SH_94
Cheers and have a nice day!