Google-sheets – Need unique values of a range in google sheets

I found a way to do it:

1. Select Column A and "Insert 1 left" to add a column. Your table data is moved over one to columns B - D.
2. In your newly blank Cell A2, enter formula
   =IF(COUNTIF($B$2:$B2,B2)=1, "Unique", "Duplicate")
3. Copy the formula from A1 and paste it down the A column range for as far as you have data. The "$" absolute references will ensure everything works smoothly.
4. Add a new sheet. Copy and paste your old sheet's B - D column headers to the new sheet's A - C.
5. In the your new sheet's cell A2, enter formula
   =FILTER(OldSheet!B2:D5, OldSheet!A2:A5 = "Unique")
6. Your new sheet now has your old sheets data -- Deduplicated!

I use it with ImportRange to separate Data Entry from Data Processing, so ImportData shouldn't present a problem.

You can hide the A column on your old sheet if you like.

Best of all, everything updates live on edit. So you can continue adding data to OldSheet and NewSheet will be always be current with filtered rows.

You want a pivot table.

Select the original data, choose Data > Pivot Table.

From the Pivot Table Editor, add as ROW the column "Date", as COLUMN the "Country", and as VALUE the "Title"

Result: