how to avoid duplicate rows in power bi report by showing differed entries in same row?

[DivyaNair]

I need to show a power bi visualisation in table format below.

where A= IF(Table[col]="A","X",BLANK())

B= IF(Table[col]="B","X",BLANK())

C= IF(Table[col]="C","X",BLANK())

D= IF(Table[col]="D","X",BLANK())

But after creating A, B, C and D columns when I drag this fields to table visualisation I get table with below format

how can I achieve the required format?

Thanks in advance.

[DivyaNair]

adding data sample for easy to understand my question. My required table format is

and am getting below one

where

[v-yuta-msft]

@DivyaNair ,

It seems like you've forgot to add the column number. 

A =
IF ( Table[Col1] = "A", "X", blank )

B =
IF ( Table[Col2] = "B", "X", blank )

C =
IF ( Table[Col3] = "C", "X", blank )

D =
IF ( Table[Col4] = "D", "X", blank )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DivyaNair]

A,B,C and D are derived from same column. something like column 5 has values A, B, C and D then mark it as X if it exists