Hatzimichelakis
New Member
- Joined
- Nov 22, 2017
- Messages
- 8
A | B | C | D | E | F | G | |
1 | FALSE | George | FALSE | FALSE | John | FALSE | Helen |
2 | George | John | Helen |
<tbody>
</tbody>
How to take only the TRUE results of the row1 in the row 2 one next the other?
A | B | C | D | E | F | G | |
1 | FALSE | George | FALSE | FALSE | John | FALSE | Helen |
2 | George | John | Helen |
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | FALSE | George | FALSE | FALSE | John | FALSE | Helen |
2 | George | John | Helen |
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
FALSE | George | FALSE | FALSE | John | FALSE | Helen |
FALSE |