get name only false & only true
how do i get to fill these columns with places' names from the already filled columns and get the selection automatically? in the true column there should be names of places that have true status and in the false column the names of those places that have false status
| places | status | true | false |
|---|---|---|---|
pyrgos 1 | true | ||
| pyrgos 2 | false | ||
| pyrgos 3 | true | ||
| proikalmi 1 | false | ||
| proikalmi 2 | true | ||
| stavrodromes 1 | false | ||
| stavrodromes 2 | false | ||
| kikiristeza | true |
thank you
Dell Inspiron 15 -OTHER, Windows 8, Windows 10 Home