Forum Discussion
Solved
Grouping multiple columns in Power Query
Hi,
I am trying to GROUP BY the following data
| Prod | Mat A | Mat B |
| A | A-1 | |
| A | A-2 | |
| A | A | |
| B | B-1 | |
| B | B-2 | |
| B | B-3 | |
| B | B | |
| C | C-1 | |
| C | C-1 |
into this one below.
| Prod | Mat A | Mat B |
| A | A-1 | |
| A | A-2 | A |
| B | B-1 | |
| B | B-2 | |
| B | B | B-3 |
| C | C-1 | C-1 |
Is this possible ? I thought I could do it using Power Query but
I cannot figure out how.
Can anyone please help ?
Hi hideakisuzuki01 check link below, you can group ony or more columns. I hope this help
2 Replies
Hi hideakisuzuki01 check link below, you can group ony or more columns. I hope this help
Thanks !
