Forum Discussion
Splitting a column
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.
Hi Cilliann
There must be another column like ID column to related date and accepted values together like thisif 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.
5 Replies
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.
Hi,
Sorry, if I expressed myself unclearly, I am attaching a screenshot of what I am trying to achieve eventually:
Can you please help?
Hi Cilliann
There must be another column like ID column to related date and accepted values together like thisif 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.
