The data in the left side of the table is what i have, i want to remove "sections" that are "0", however there are "cat" with all "section" equals to "0", and i would like to keep this "cat" as shown in the right side of the table.
cat | section | T/F | cat | section | T/F | |
1 | A | 1 | 1 | A | 1 | |
1 | B | 0 | 2 | D | 1 | |
1 | C | 0 | 3 | null | null | |
1 | D | 0 | 4 | null | null | |
2 | A | 0 | 5 | null | null | |
2 | B | 0 | 6 | null | null | |
2 | C | 0 | 7 | any of the letter | 0 | |
2 | D | 1 | ||||
3 | null | null | ||||
4 | null | null | ||||
5 | null | null | ||||
6 | null | null | ||||
7 | A | 0 | ||||
7 | B | 0 | ||||
7 | C | 0 | ||||
7 | D | 0 |
Solved! Go to Solution.
User | Count |
---|---|
156 | |
96 | |
80 | |
70 | |
70 |