Project 1 - Data Cleaning and Transformation using Pivot Table and Charts

1. =UNIQUE(array,[by_col],[exactly_once])

2. In excel there is no structure or syntax of formula but functions do have a syntax. Every function has its own pre-designed parameters basis through which a function executes results. A formula can never have pre-defined parameters.

3. OK

5. M formula language is use in power query.

6. Home > Transform > Data Type