I have a case statement

```
Select customer, group, case when group = one then 'A' else 'B' end as Indicator FROM TABLE1

```

How do I "flatten" the indicator so for each customer I have 2 column for each indicator type (Goal Table)

Current Table:

| Customer | Group | Indicator |
| --- | --- | --- |
| Joh | One | A |
| Joh | Two | B |
| Jane | One | A |
| Jane | Two | B |

Goal Table:

| Customer | Indicator1 | Indicator2 |
| --- | --- | --- |
| Joh | A | B |
| Jane | A | B |