Table Functions

Function	Signature	Purpose
`Table.SelectRows`	`(table, condition)`	Filter rows by a boolean condition
`Table.SelectColumns`	`(table, columns)`	Keep only named columns
`Table.RemoveColumns`	`(table, columns)`	Drop named columns
`Table.AddColumn`	`(table, name, fn, type?)`	Add computed column
`Table.RenameColumns`	`(table, renames)`	Rename columns via pairs list
`Table.ReorderColumns`	`(table, order)`	Change column display order
`Table.TransformColumnTypes`	`(table, transforms)`	Set/change column data types
`Table.TransformColumns`	`(table, transforms)`	Apply function to column values
`Table.ReplaceValue`	`(table, old, new, replacer, cols)`	Find and replace in columns
`Table.Sort`	`(table, criteria)`	Sort by one or more columns
`Table.Group`	`(table, keys, aggregations)`	Group by keys with aggregations
`Table.Distinct`	`(table, columns?)`	Remove duplicate rows
`Table.FirstN`	`(table, n)`	Take first N rows
`Table.Skip`	`(table, n)`	Skip first N rows
`Table.RowCount`	`(table)`	Count rows in table
`Table.ColumnNames`	`(table)`	Get list of column names
`Table.Combine`	`(tables)`	Stack tables vertically (UNION)
`Table.PromoteHeaders`	`(table, options?)`	Use first row as column headers
`Table.Pivot`	`(table, pivotValues, attrCol, valCol, aggFn)`	Rows → columns

Included with Excel Power Query Templates