Text transformations

A request from the patient experience committee has come your way. They are looking to derive some insights from the patient satisfaction survey results to support their improvement project.

Your task will be to conduct the appropriate text transformations in order to derive what they are looking for.

If you lost any progress, load the 3_1_text_transformation.xlsx workbook from the Exercises folder and open the Power Query editor.