Forum Discussion
Solved
power query formula needed
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 ...
Your criteria for Data1 and Data2 are unclear. Please explain the logic again.
Data 1 and Data 2 columns are results for Name column. Data 1 and Data 2 columns will either have 1 or 0.
There may be up to 15 rows for the same data in the Name column. The Data 1 and Data 2 columns for the 15 rows may be the same or have different values. If Data 1 and Data 2 are the same for a number of rows I want to know if they match for the value in the Name column.
Example:
| Name | Data 1 | Data 2 |
| Name 1 | 1 | 0 |
| Name 1 | 1 | 0 |
| Name 1 | 0 | 0 |
| Name 1 | 0 | 0 |
| Name 1 | 1 | 0 |
| Name 1 | 1 | 1 |
| Name 1 | 1 | 1 |
| Name 1 | 1 | 1 |
| Name 1 | 1 | 1 |
| Name 1 | 0 | 1 |
| Name 2 | 1 | 0 |
| Name 2 | 1 | 0 |
| Name 2 | 0 | 0 |
| Name 2 | 0 | 0 |
| Name 2 | 1 | 0 |
| Name 2 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |
| Name 3 | 1 | 1 |