2D Array question

[Daveton]

I have built a 2D array of strings, which is sorted alphabetically by column 0. Column 0 will be headings, and column 1 is the data. I want to search the array by row 0 to n-1, column 0 and blank out the duplicate items, while leaving all of the data in column 2.

[Ben]

Hi Daveton,

If I understand you correctly, after your sort, duplicates entries should consecutive. So...

Try split of the first element in a collumn and use it to init a shift register. Compare each element with the previous. If equal, replace with empty string. If not keep the new value and update your shift register.

I hope this helps,

Ben