Count duplicate values across multiple columns

Maybe this is just language, but if you want to keep the dupilcates and count them, then surely you will end up with this.

                            First Name     Last Name  Address                               Number of Duplicates

Row XYZ               John               Smith          123 Sandpiper Lane             3

Row XYZ               John               Smith          123 Sandpiper Lane             3

Row XYZ               John               Smith          123 Sandpiper Lane             3

If you want to remove the duplciates and keep 1 copy of every row, then you will end up with this.

                            First Name     Last Name  Address                               Number of Duplicates

Row XYZ               John               Smith          123 Sandpiper Lane             3

You can also do this in Power Query.  Just select Group By, and then select Count.  The button is on the home tab to the right hand side of the menu

Yes, Advanced Grouping works. Thank you