How can I deduplicate a table (all rows and columns) based on the values in column A?
Example:
What I want after deduplicating:
Basically, I only want unique values in column A
, but I want all the other data to persist in the other columns, including cells with null values.
Also, all columns are derived from the =IMPORTDATA()
function in the first cell of column A
.