What Basic Transformations Can You Perform Using Power Query?
Let's examine a few simple transformation methods in this part that just require a few mouse clicks to execute.
Read More: training excel power query
1. Functions for Text Formatting
This part will teach you how to utilize the Trim operation and format text in both uppercase and lowercase letters.
UPPERCASE
Step 1: Fill in the Power Query Editor with the necessary data. To accomplish this, choose the appropriate data source from the Excel Data tab's Get & Transform Data section. This will launch the Editor, enabling us to make changes to the data.
Step 2: After selecting the column name, click the "Transform" tab to view a number of alternatives. When you select the Format text option, a drop-down menu with the text edit option "UPPERCASE" will appear.
Step 3: The te...