Hi,
I have a table with a row containing multiple values, such as below.
0
10
10
10
10
10
14
6
10
10
10
4
… and so on.
I need to replace the multiple rows of 10 with just a single 10, like so.
0
10
14
6
10
6
…
I know unique doesn't work as I can't put a condition it to work between two rows that don't have 10. So any help would be greaty appreciated. Thanks in advance!
Kahar
Best Answer