I'm trying to use Excel Power Query to filter down to only one combination of columns:
Example:
Original Table:
| Header1 | Header2 |
|---|---|
| A | B |
| B | A |
| B | C |
Desired Result:
| Header1 | Header2 |
|---|---|
| A | B |
| B | C |
Could be any combination of AB/BA as long as there is only one.
I've included a link to a demo workbook with the unfinished query. I've been going crazy trying multiple methods to get this to work.
