Hi,

Let me present the problem:
I am used to use a lot spreadsheet programs to categorize data. Let the first column contain the category, the second the data.
Example:
a | 10
a | 12
a | 30
b | 20
c | 14
d | 12
d | 50
Normally, I am using the  identical categories as merged cells, so only one "a" is visible. It is ok visually.
a | 10
  | 12
  | 30
b | 20
c | 14
d | 12
  | 50
But if I want to count the data belonging to category "a", I have only 1 as result, because it is the only "a" item in category column.
OK, I could use other methods to count them, but the actual behaviour, I think, can be better.
If the merged cells would return "a" for each contained cells, the use of formulas for merged cells could be correct.
Or filtering: using a filter, only the first row is captured, but not the rest. In the filter, I would like to see for "a":
a | 10
  | 12
  | 30
and not
a | 10
Maybe a simple checkbox would be enough:
[ ] multiply data for merged cells/ data categorize mode or an icon that change the behaviour.
... or something similar.
I don't know if it is an improvement or not, for me, it would be fine.
Thanks for your attention.