Hi,
I have a column where each record have multiple people's name. E.g.: I have 6 people - ABC, DEF, GHI, JKL, MNO, PQR.
Now I want to create 6 columns with 1 or 0 values with each person's name whether the first column has his her name.
in the table below, I have only 1 column: Name. I want to create remaining columns with 1/0 values.
| Name | is ABC | is DEF | is GHI | is JKL | is MNO | is PQR |
| ABC GHI JKL | 1 | 0 | 1 | 1 | 0 | 0 |
| DEF MNO GHI | 0 | 1 | 1 | 0 | 1 | 0 |
| PQR ABC JKL | 1 | 0 | 0 | 1 | 0 | 1 |
| DEF JKL | 0 | 1 | 0 | 1 | 0 | 0 |
| DEF GHI ABC JKL | 1 | 1 | 1 | 1 | 0 | 0 |
Really appreciate your help.
