Re: How to split a column with two different value...

Anonymous · ‎11-09-2019

I have transformed a messy data that had 3 headers and before transformation the procentage and whole numbers had seperate columns now when I used Transpose, unpoviot and etc. I got a new column with "Values" that are included both procentage and whole number. How can I split them to seperate column again?

Nathaniel_C · ‎11-09-2019

Hi @Anonymous ,
Go to Power Query, Home tab, Split Columns, choose Location and bingo!

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Anonymous · ‎11-11-2019

Not really that funcition because the values are in same column but in same rows. Sorry if I was not clear.

v-diye-msft · ‎11-11-2019

Hi @Anonymous

Please share some samples that we can understand it more. simple excel/dummy pbix with expected results will be preferred.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.