Power Query Formula

Question

I am trying to find matches on multiple rows and then concatonate to only see one record returned when all criteria is the same using 1 table.
1st I have 3 columns, the 1st column is a name, the 2nd and 3d columns are what I need to see if they match on several rows.
2nd. I then need to see how to compare the results are on all locations.
3rd. If the name and 2nd and 3rd columns match and are on all locations, I only want 1 record returned.

Or
If I have to do in 2 queries

1. what is best way to find maches for Name, Data 1 and Data 2 columns on multiple rows
2. How to then complare 1st results to Location

Example:
Column 1 = Location
Column 2 - name
Column 3 & Collumn 4 data is either 0 or 1
In my example for Name 3 I only want to see 1 record since everything matches

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--