Delete consecutive repeating values
I have a data table where some of the columns have values that repeat because the program that generates the data holds the last value if a new one isn't given. This means I can't use the "select duplicate rows" option because that deletes all duplicates not just ones that are repeating. I also don't want to delete the rows, just the values in the "cells". 4.13.43.4 - delete value3.4 - delete val...