Dynamically delete duplicate rows - leave no gaps

[dslhs]

Hi,

I have a table (A2 = Names, B2 = Courses). There are multiple duplicate rows - where the information in both the A column and B column are exactly the same. I would like to re-create the table, but without any duplicate rows. There will be duplicates in the A column, and in the B column, but I don't want there to be A&B. I'd also like the new linked table to have no row gaps.

I know I can Go to the Data tab > Data Tools group, and click the Remove Duplicates, but I'd like this to be dynamic as the table is linked to external data.

I don't have the 'Unique' function, as I'm in 2019.

Many thanks,

 

[dslhs]

Brilliant! Thank you so much for your help.

I have one more question. Is there a way of using power query Mcode to delete the last row in the table? Again it would be dynamic, but looking to always delete the last row.

Many many thanks,

 

[alansidman]

On the PQE ribbon, click on Remove rows and select the number of rows from the bottom you wish to delete.