Combine Multiple Power Query Excel Files
This tutorial will show you how to combine table from multiple excel files produced from power query into one table also with power query.
Tagged: query
Use QUERY Formula in Google Sheet as Replacement of PivotTable Function
QUERY formula can be used as replacement of PivotTable function. However this formula can only be used in Google Sheet not other spreadsheet application.
