Is there any way of checking if any of the fields for different rows are the same

Before:

Desired Result - This is desired result.

We will have the reference of all lines that are the same and it will be easy to filter and the last column will be a count, so basically, the higher the number, the more fields that are the same for different rows.

This looks demanding for me, but I hope you one you, it will be a possible. It will help so much.