Hello - My Excel 2007 pivot table is mostly established, but I'm having problems with grouping of member types based on a member number. It is the last character in a member number which allows me to know if a person is a member, or a spouse or child of that member.
I need to group spouse as...