04 Commodore James Norrington’s pirate ship information / query sheet. D. INDEX MATCH with MAX. Now, Norrington wants to know how many pirates are on the most populated ship, ...

First, we’ll load the data into Power Query. Then, we’ll add an index column, so you can visually see which products belong to the same order.