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

1. UNIQUE(B2:B12&" "&A2:A12)

2. Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters.

5. the Power Query M formula language, also known as M.

6. Select the Date column, select Home > Transform > Data Type, and then select the Date option. You can convert other numeric types, such as percentage or currency.