I have a excel sheet(csv) like this one:
and I want the output(tab delimited) to be like this:
Basically:
I am struggling to create a formula which would do this. If I try to "Remove Duplicates" it removes the value and shifts the values up one row. I want it to remove the duplicates but not shift the values up.
Given that duplicate data cells are next to each other
and data are on column A with blank top row, this should work. It will remove duplicates except the first occurrence.
=IF(A1=A2,"",A2)
=IF(A2=A3,"",A3)
.
.
.