Jan 24 2022 11:04 AM
Jan 24 2022 11:16 AM
@ONUnicorn2 Don't use merged cells. They are "evil" and only cause trouble. Just repeat cells for each child, even when they are common for all within the family. Then you can sort, filter how you want. Merge cells and all of this goes away.
Jan 24 2022 12:51 PM
Jan 24 2022 09:11 PM
@ONUnicorn2 You mentioned a client can have multiple children, and I understood that you were merging cells with e.g. the address. All live on the same address, so this is "not particular to one child". Don't do that, but repeat the same address for each child. That way, each row contains all relevant information for each individual.
Feb 14 2022 09:14 AM