thegameoflife
Programmer
I have a table with member address info in it. I need to find a way to group the members together by addresses in groups of three and if there is less than three unique member Address in a the series insert the word "void" in the row or rows to make a group of three. HELP!!!
Example
Table before:
Member Name Address City State Zip
John Doe 101 Home St Austin TX 78750
Jane Doe 101 Home St Austin TX 78750
Bruce Lee 50 Lee St Austin TX 75785
Table after:
Member Name Address City State Zip
John Doe 101 Home St Austin TX 78750
Jane Doe 101 Home St Austin TX 78750
VOID VOID VOID VOID VOID
Bruce Lee 50 Lee St Austin TX 75785
VOID VOID VOID VOID VOID
VOID VOID VOID VOID VOID
Example
Table before:
Member Name Address City State Zip
John Doe 101 Home St Austin TX 78750
Jane Doe 101 Home St Austin TX 78750
Bruce Lee 50 Lee St Austin TX 75785
Table after:
Member Name Address City State Zip
John Doe 101 Home St Austin TX 78750
Jane Doe 101 Home St Austin TX 78750
VOID VOID VOID VOID VOID
Bruce Lee 50 Lee St Austin TX 75785
VOID VOID VOID VOID VOID
VOID VOID VOID VOID VOID