Nice idea but it doesn't fully work. Splitting will only affect the rows that need it. With this filter I could shelter the rows that I don't want to be affected by the 'fill down' process (which, I'm guessing, is what you're suggesting this for), but this still doesn't stop the 'fill down' from affecting consecutive split rows - i.e. after the fill I would find TRUE in the DrinksTea column for Kevin and Barry.
jquartel
8
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| "split multi-valued cells" seems to affect non-matching rows | 4 | 551 | July 19, 2023 | |
| Two ways of feature extraction: 1. split multi-value cells; 2. split into multiple columns | 6 | 1657 | March 24, 2023 | |
| Convert your rows of data into multi-row records | 4 | 611 | January 20, 2024 | |
| Joining Multi Value Cells Not Completing | 6 | 653 | November 7, 2023 | |
| Merging and dedublicating | 6 | 1945 | December 2, 2022 |