Spreadsheet: 78004d1278463385-need-to-filter-down-employee-info-that-is-grouped-across-multiple-rows-ee-data-in-groups-example
Sheet: Desired Output

E ******6968 | SSN1 | First Name 1 | MI 1 | Last Name 1 | Last Name 1 | Address 1 |  | Address 1 | City 1 | [NAME] | NNNNFH20080519 | N | 301527PMAReturn | Postage Guaranteed | R
WSS_EE |  | 29860 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 29860 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WFUTA |  | 3853 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 3853 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WFIT |  | 46251 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 46251 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WMEDICARE_EE |  | 6983 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 6983 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WGASUIER |  | 21384 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 21384 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
[NAME] |  | 6983 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 6983 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WSS_ER |  | 29860 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 29860 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
WGASITEE |  | 21328 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 21328 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
E ******6032 | SSN13 | First Name 13 | MI 13 | Last Name 13 | Last Name 13 | Address 13 |  | Address 13 | City 13 | StateZip13 | NNNNFH20030919 | N | 301175PMAReturn | Postage Guaranteed | R
WSS_EE |  | 41634 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 41634 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
WFUTA |  | 5372 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 5372 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
WMEDICARE_EE |  | 9737 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 9737 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
WGASUIER |  | 29815 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 29815 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
[NAME] |  | 9737 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 9737 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
WSS_ER |  | 41634 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 41634 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
 |  |  | OR
E ******6968 | SSN1 | First Name 1 | MI 1 | Last Name 1 | Last Name 1 | Address 1 |  | Address 1 | City 1 | [NAME] | NNNNFH20080519 | N | 301527PMAReturn | Postage Guaranteed | R
WGASUIER |  | 21384 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 21384 | 523685 | 481613 | 481613 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000000 | 0 | SN1 | NN | N0 | 122000 | Y | Y | Y | Y | 10 | 402 | 0 | 0 | 0 | N
E ******6032 | SSN13 | First Name 13 | MI 13 | Last Name 13 | Last Name 13 | Address 13 |  | Address 13 | City 13 | StateZip13 | NNNNFH20030919 | N | 301175PMAReturn | Postage Guaranteed | R
WGASUIER |  | 29815 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 29815 | 694207 | 671515 | 671515 | 0 | 0 | 0 | 0 | 0 | SNN00000000000000003 | 0 | SN1 | NN | N0 | 143500 | Y | Y | Y | Y | 10 | 405 | 0 | 0 | 0 | N
 |  |  | OR
E ******6968 | SSN1 | First Name 1 | MI 1 | Last Name 1 | Last Name 1 | Address 1 |  | Address 1 | City 1 | [NAME] | NNNNFH20080519 | N | 301527PMAReturn | Postage Guaranteed | R
E ******6032 | SSN13 | First Name 13 | MI 13 | Last Name 13 | Last Name 13 | Address 13 |  | Address 13 | City 13 | StateZip13 | NNNNFH20030919 | N | 301175PMAReturn | Postage Guaranteed | R