Transform table as per picture attached

[msbiuser1]

 The result required is as 

Thanks in advance

[saravanan_p · Accepted solution]

Use filter pane and go to field weekplanning_Competetor and uncheck other values and check only blanks. Your result would be populated.

KIndly give thumps up and mark as solution