after you promote the header, sometime it required to demote back the header back to rows.
to output back to the excel.
input:
| Country_Shop_Sales | UK_Shop1_James | UK_Shop1_Quuin | UK_Shop2_Jack | UK_Shop2_Don | US_Shop3_Kim | US_Shop3_Bob | US_Shop4_Kinston | US_Shop4_Hua |
| Sales Amount | 1000 | 1010 | 1200 | 2043 | 2000 | 3000 | 4000 | 5000 |
output:
| Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8 | Field9 |
| Country | UK | UK | UK | UK | US | US | US | US |
| Shop | Shop1 | Shop1 | Shop2 | Shop2 | Shop3 | Shop3 | Shop4 | Shop4 |
| Sales | James | Quuin | Jack | Don | Kim | Bob | Kinston | Hua |
| Sales Amount | 1000 | 1010 | 1200 | 2043 | 2000 | 3000 | 4000 | 5000 |