Hi
If I have a table like this in power query:
| Supplier ID | Region | Survey status? |
| 1535 | Germany | Complete and Up to Date |
| 1563 | Germany | Complete and Up to Date |
| 2786 | Germany | Complete and Up to Date |
| 1612 | France | Complete but Out of Date |
| 2057 | Germany | Incomplete |
| 4309 | Germany | Complete and Up to Date |
| 3717 | Brazil | Complete and Up to Date |
| 1867 | Spain | Not Submitted |
| 4130 | Brazil | Complete and Up to Date |
| 4624 | China | Complete and Up to Date |
| 4068 | China | Complete and Up to Date |
| 3531 | Germany | Complete and Up to Date |
| 2469 | Germany | Complete but Out of Date |
| 2666 | China | Complete and Up to Date |
| 4798 | China | Complete and Up to Date |
| 4079 | Germany | Complete and Up to Date |
| 1734 | Germany | Complete and Up to Date |
| 4650 | Germany | Complete and Up to Date |
| 1770 | France | Complete but Out of Date |
| 3047 | Germany | Complete and Up to Date |
| 1605 | Germany | Complete and Up to Date |
| 2635 | Brazil | Complete and Up to Date |
| 4223 | Spain | Complete and Up to Date |
| 1491 | Brazil | Complete and Up to Date |
| 4412 | China | Complete and Up to Date |
| 2359 | China | Complete and Up to Date |
| 2356 | Germany | Complete and Up to Date |
| 1373 | Germany | Complete but Out of Date |
| 4659 | China | Complete and Up to Date |
| 3961 | China | Complete and Up to Date |
How do i get it into this format:
| Count of Supplier ID | Column Labels | | | |
| Row Labels | Complete and Up to Date | Complete but Out of Date | Incomplete | Not Submitted | Grand Total |
| Germany | 51 | | 1 | 3 | 55 |
| Brazil | 30 | | 6 | | 36 |
| France | 63 | 8 | 11 | 1 | 83 |
| Spain | 8 | 1 | 2 | | 11 |
| China | 281 | 36 | 58 | 9 | 384 |
| Grand Total | 433 | 45 | 78 | 13 | 569 |
essentially i want to do a count of the supplier ID's per country for each status they are in. Please help!
