Hello,
I am using World Bank data and want to create a database I can use for further analysis.
I have a Column called Target which lists the different SDG targets in the format of 1.1, 1.2, 1.2.1 etc.
Each Row has Target number and the Value of said target.
I would like to create new columns which are are named by the target and have the value of said target. I have been trying to get this to work using power query but I am stuck.
The Idea is that then I have a Column for 1.1 another for 1.2 etc thereby reducing the number of rows I have in total.
I would greatly appreciate help and attached example data.
Best Regards
Raul
Bookmarks