Scenario:

Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.

Scenario:

In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single.