Splitting a column

[Cilliann]

Hello,

I know the answer might be simple, but I am a relatively new Power BI user. I need to split Column1 into two columns to have Date and Accepted as separate columns. Not sure how to achieve that.

Thank you.

[AnushaSri · Accepted solution]

Hi @Cilliann 

There must be another column like ID column to related date and accepted values together like this 

if yes, then go to power query and to the table, select column1 and go to transform and click on pivot column like this 

then select coloumn2 in the Values Column and go to advance options and select don't aggregate. 

Press ok to see the transformed result as below 

Hope it resolves your isssue.

Please accept this as a solution, if it resolve your issue. Also please give me kudos.

Thanks in advance.

[Cilliann]

Your solution actually works for me as well! Thank you!

[Cilliann]

Hi,

Sorry, if I expressed myself unclearly, I am attaching a screenshot of what I am trying to achieve eventually:

Can you please help?

[justlearning50]

Hi @Cilliann ,

In edit query, select the query you are interested in, then select Transform>Transpose (to change columns to rows)> (may need Reverse rows) > Home>Use first row as header to get Date and Accepted as the header. 

Hope this works for you. 

[Cilliann]

Hi,

Sorry, if I expressed myself unclearly, I am attaching a screenshot of what I am trying to achieve eventually:

Can you please help?