Hi, I have the following table:
2AA 2AB 2AC 2AD 2AE
Finance 100 10 100 10 100
HR 200 20 200 20 200
ICT 300 30 300 30 300
Finance 400 40 400 40 400
HR 500 50 500 50 500
ICT 600 60 600 60 600
Finance 700 70 700 70 700
HR 800 80 800 80 800
ICT 900 90 900 90 900
and I need to take the data and transpose the headings but then get the total of each as follows:
Finance ICT HR
2AA 1200 1800
2AB 120
2AC
2AD
2AE
Is there a simple way of doing this? I have attched the excel spreadsheet if that helps.
thanks
Bookmarks