Power Query is available as part of the interface through Excel 2016. Excel for the web doesn’t support Power Query, ... The example data is in a Table named TableSales.

Admittedly, in such a simple example, using Power Query seems like overkill. Initially, you don’t seem to be saving any time or effort. However, imagine that you’re working with a much larger ...