Need to find each areas no of 5 for each indicator, and 4s, 3s and 1s

Najam_Ahmed 

I do so detest the nested array limitation of Excel.  The desired result almost always is an array of arrays and this makes it so difficult to output the entire results using a single dynamic formula.  I do not want to always be searching for the least-worst workaround (in this case using MAKEARRAY)!

= LET(
    distinctAreas,      UNIQUE(Table1[Area]),
    indicatorHeadings,  DROP(Table1[#Headers], , 1),
    indicatorResults,   DROP(Table1, , 1),
    areaAttribute,      TOCOL(IF(ISTEXT(indicatorHeadings), distinctAreas)),
    indicatorAttr,      TOCOL(IF(ISTEXT(distinctAreas), indicatorHeadings)),
    countAreaIndicator, COUNTA(distinctAreas) * COUNTA(indicatorHeadings),
    resultCounts,       MAKEARRAY(countAreaIndicator, 5,
      LAMBDA(r,c,
        LET(
          indicatorResults, INDEX(indicatorResults, 0, 1 + MOD(r - 1, 11)),
          COUNTIFS(Table1[Area], INDEX(areaAttribute, r), indicatorResults, 6-c)
        )
      )
    ),
    HSTACK(areaAttribute, indicatorAttr, resultCounts)
  )