Question: How to convert boolean True or False to "Yes" or "No" in Google Sheets?

```
=REGEXMATCH(A1;"word")

```

Answer: 
use conditional aggregation with `case when expression`

```
select 
  a.Unique_ID,Status,Decision,
  max(case when Warning_Code=1 then Warning end) as Warning_1,
  max(case when Warning_Code=2 then Warning end) as Warning_2,
  max(case when Warning_Code=3 then Warning end) as Warning_3,
  max(case when Warning_Code=4 then Warning end) as Warning_4
from tableA a inner join tableB b on a.Unique_ID=b.Unique_ID
group by a.Unique_ID,Status,Decision

```
use case when with aggregation

```
select Unique_ID,Status ,Decision,
max(case when Warning_Code=1 then Warning end) as waring1
max(case when Warning_Code=2 then Warning end) waring2,
max(case when Warning_Code=3 then Warning end) waring3
from tablea a join tableb b on a.Unique_ID=b.Unique_ID 
group by Unique_ID,Status ,Decision

```