Spliting column in to separate columns

[Justas4478]

Hello I am trying to split Information column in to 3 new columns that have only one value in each of them.

I hope attached image can show expected results better than my explanation.

Information is the original column and SplitA-B and C are results of split that I am trying to get.

I am sure it can be done but nothing I try so far seems to work.

 

Thanks.

[amitchandak]

@Justas4478 , You have to create new column like

Power query

if [information] ="Check-in Informtion" then "Check-in Informtion"

DAX

if([information] ="Check-in Informtion" ,"Check-in Informtion", blank())

create other columns like that

[Justas4478 · Accepted solution]

I manage to do it using Conditional Column from Add Column tab in transform data.