Given all your columns are the same datatype
you could do something like
Select districtid,AssessmentAreadId,assessmenttypeid,Convert(VarChar(16),'ANC') as TypeOfTotal, TotalANCStds as Total
Union all
Select districtid,AssessmentAreadId,assessmenttypeid,'NLD', TotalNLDStds
Union all
...
Or (for just two totals)
Select districtid,AssessmentAreadId,assessmenttypeid, TotalANCStds, Convert(int,0) as TotalNLDStds
Union all
Select districtid,AssessmentAreadId,assessmenttypeid, 0,TotalNLDStds
then you can sum it with
Select districtid,AssessmentAreadId,assessmenttypeid, Sum(TotalANCStds) and TotalANC,Sum(TotalNLDStds) as TotalNLD
Group By districtid,AssessmentAreadId,assessmenttypeid
More total colums is just starting off with more columns in teh first query and inserting the requite number of 0s.
HtHs