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

```
It is basic pivot query, you only have to make left join, in case any row in `A` has no decisions in `B`:

```
select *
  from a left join b using (unique_id)
  pivot (max(warning) for warning_code in (1 w1, 2 w2, 3 w3, 4 w4))

```

**[demo](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=37b9506aed7424d5242755c4ba194f64)**