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 |