I have an requirement where i have to read multiple header and then transpose the sum.
Requirement:- Excel tab with Multiple header, i have to extract the figure.
i.e. HR = 45000
Finance = 22323
Team4 = 16000(8000+8000)
After need to write that data in there Columns
And the code should be dynamic so that if any other team added it should print accordingly.
Any Suggestion Guys? Attache the sample ExcelMIS Sheet.xlsx (21.0 KB)