Table

Table Module

Table.AddBlankRow

Transforms a column's value into its nested value -- if it eventually finds only one

Table.DrillIntoColumn

Table.EnterDataFormula

Convert a table into a formula that's compatible with the Enter Data UI. This function returns an expression you can copy and paste to edit the table using Enter Data. Paste the formula, then click the gear icon next to the step name. This is an easy way to allow people to customize a table you've queried

Table.FromListCrossJoin

Perform a cross join of lists

Table.JsonDecode

Table.JsonEncode

Table.ReplaceValueIf

Replaces a value if it matches a predicate

Table.SplitColumnNames

Splits camelCased and PascalCased column names.

Table.SplitColumnText

Splits camelCased and PascalCased text in a column.

Table.TransformColumn

Table.RenameColumn

Table.RenameAndTransformColumn

Table.ToXml

Transforms a table into an XML document