Forum Discussion
Data shaping
Hi mariakos,
Translate the data in power query, rename column 1,2,3 to year, country and topics first:
Then split the country column with multiple values with delimiter:
In my test, I used a comma as the delimiter, and you can choose a different delimiter if needed.
Before:
Later:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mariakos,
Translate the data in power query, rename column 1,2,3 to year, country and topics first:
Then split the country column with multiple values with delimiter:
In my test, I used a comma as the delimiter, and you can choose a different delimiter if needed.
Before:
Later:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.