Forum Discussion
How to extract new table for comparison
From this table
| distributor | product | qty |
| A | apple | 3 |
| A | mango | 5 |
| B | apple | 1 |
| B | mango | 2 |
| C | mango | 2 |
convert to
| products | A | B | C |
| apple | 3 | 1 | |
| mango | 5 | 2 | 2 |
2 Replies
- amitchandak
Super User
arichard19Resolver I
The easiest method would be to pivot the table within Power Query
https://docs.microsoft.com/en-us/power-query/pivot-columns