Convert rows from multiple columns into a single column

[datawhale]

I have the following table:

I would like to create a single column from the three columns (good, caution, critical) only for value 'b'. The result should be like:

(note: id and id_1 are identical)

[Padycosmos · Accepted solution]

Hope this helps

[vicky_]

This should get you started - just add more if conditions (or use switch) to add in the rest.

Table 2 = SUMMARIZE('Table', 'Table'[id], "status", IF(CONTAINSSTRING(VALUES('Table'[good]), "b"), "Good") )