Forum Discussion
Problem with sorting and filtering
This is my table.When I filter the first column and I choose Vodovod, I only get the first row and not the entire 17 rows that I need.
Is there a way to make this work?
Hi Mufid,
If only unmerged the cells and repeat the value in each row. Actually your value "Vodovod" is in cell A2, next ones (A3, etc.) are empty.
- Thank for the reply. So there is no way that I can get these 17 rows to act like one when I'm filtering?
There is the workaround https://www.extendoffice.com/documents/excel/1955-excel-filter-merged-cells.html
but better to avoid merged cells
