Hello, I am trying to figure out a way to transpose multiple headers to a row field. Here is my data: MTDMTDMTDMTDMTDMTD ActualActualActualActualActualActual Group AGroup AGroup AGroup AGroup AGroup A JanFebMarAprMayJun FY19FY19FY20FY20FY21FY21Total CostTypeRevenue100000100000100000100000100000100000DirectCostSalary500005000050000500005000050000DirectCostBonus200020002000200020002000DirectCostHealthcare Cost150015001500150015001500 I want the result to be : Total CostTypeRevenueMTDActualGroup AJanFY19100000Total CostTypeRevenueMTDActualGroup AFebFY19100000Total CostTypeRevenueMTDActualGroup AMarFY20100000Total CostTypeRevenueMTDActualGroup AAprFY20100000Total CostTypeRevenueMTDActualGroup AMayFY21100000Total CostTypeRevenueMTDActualGroup AJunFY21100000DirectCostSalaryMTDActualGroup AJanFY1950000DirectCostSalaryMTDActualGroup AFebFY1950000DirectCostSalaryMTDActualGroup AMarFY2050000DirectCostSalaryMTDActualGroup AAprFY2050000DirectCostSalaryMTDActualGroup AMayFY2150000DirectCostSalaryMTDActualGroup AJunFY2150000DirectCostBonusMTDActualGroup AJanFY192000DirectCostBonusMTDActualGroup AFebFY192000DirectCostBonusMTDActualGroup AMarFY202000DirectCostBonusMTDActualGroup AAprFY202000DirectCostBonusMTDActualGroup AMayFY212000DirectCostBonusMTDActualGroup AJunFY212000DirectCostHealthcare CostMTDActualGroup AJanFY191500DirectCostHealthcare CostMTDActualGroup AFebFY191500DirectCostHealthcare CostMTDActualGroup AMarFY201500DirectCostHealthcare CostMTDActualGroup AAprFY201500DirectCostHealthcare CostMTDActualGroup AMayFY211500DirectCostHealthcare CostMTDActualGroup AJunFY211500 Thank you so much for your help. Srini

How to Transpose multiple headers to rows

Hello,

I am trying to figure out a way to transpose multiple headers to a row field.

Here is my data:

I want the result to be :