Matrix/Table from an unusual dataset

[Maria9292]

Hi everyone!

I have a dataset like this:

Basically in every row No 1 has got value in column "status 1", No 2 has got value in a colum "Status 2" etc.

I am trying to figure out how to convert this dataset into matrix or table like this:

Would you be able to share any ideas how to do this? 

Thanks!

[ryan_mayu · Accepted solution]

@Maria9292 

you can try to create a new table

Table 2 = 
VAR t1=SELECTCOLUMNS('Table',"No",'Table'[No1],"Status",'Table'[status1])
VAR t2=SELECTCOLUMNS('Table',"No",'Table'[No2],"Status",'Table'[status2])
VAR t3=SELECTCOLUMNS('Table',"No",'Table'[No3],"Status",'Table'[status3])
RETURN UNION(t1,t2,t3)

[Maria9292]

@ryan_mayu Thank you very much! It works!

[ryan_mayu]

@Maria9292 

you are welcome.