Amount of non empty cells per row in a matrix and group them

[Anonymous]

I have a matrix as shown in the picture.
The rows are just the values of column SUP from my_data_table, the columns is the LETTERS column from my_data_table and values are the COUNT of ID_NUMBER in the same data table.
Since some combinations of SUP and LETTERS do not exist, some cells in the matrix are empty.
I want to first of all count those non empty cells per row and add IF possible just 1 extra column that will have this amount in it.

Secondly, I want to create a visual, (either matrix or table) that will count the amount of non empty cells per row in the matrix and group them depending on that amount.
For example in the image shown, 1 non empty cell is found in 1 row, 2 non empty cell is found in 1 row, 3 non empty are found in 3 row, 4 non empty are found in 4 rows and so on.
So the visual should look likes this
| 1 | 1 |
| 2 | 1 |

| 3 | 3 |

| 4 | 4 |
and so on.

[lbendlin]

I want to first of all count those non empty cells per row 

Think of that row as a filter context. Your filter is the Supplier. Create a summary of the Letters (for example via SUMMARIZE()  or even VALUES()) and count the rows of the resulting virtual table. That's it.