Hello, let’s say I have a table on which I merged the cells A1 to A8 (1 col x 8 rows), and then I have cells filled with data from B1 to C8 e.g. (2 col x 8 rows). Then repeat this format on rows 9 to 16, 17 to 24, etc…
When I use the Search feature using the text I entered in the merged cell [A1:A8], I only see the row where the 1st row (B1 & C1 cells), I was expecting to see the full block [A1:A8]+[B1:C8] ranges. Similarly the sorting on Column A is then “disturbed”, to say the least :)
Could you please fix that?
Thanks in advance