Split & add prefix

Your manager wants you to analyze the geographical spread of our resellers. In order to do this, you will need to extract meaningful information from the Location column present in your dataset. You will accomplish this with the Split Columns transformation in Power Query.

Finally, your manager wants you to convert the ResellerKey column into a UniqueResellerKey column by adding a prefix to it that is unique across all our datasets.

If you lost any progress, load the workbook 3_3_split_prefix.pbix from the Exercises folder on the Desktop and open the Power Query editor.