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.
Thank you for your help. Sorry for the delay in my response. I was away and had limited access to the internet.
The data doesn't feed into Power BI clearly like you have interpreted it with column 1, column 2 and column 3. Each data input is labelled with either 1, 2 or 3 (not the columns -which are more than 3). These are also not ordered from 1-3 as you can see in the image but scattered throughout more than 3 columns across the data input. Is there a way to structure this?
Thank you Maria