Hello,
I need to return a unique list of employee IDs if a column contains specific text. I need to vstack EEID if Column B contains Supplemental Life Insurance. With no duplicates, desired result below.
I need to return a unique list of employee IDs if a column contains specific text. I need to vstack EEID if Column B contains Supplemental Life Insurance. With no duplicates, desired result below.
0090 | Supplemental Life Insurance | Children-Supplemental Life and AD&D -Child Only |
0090 | Supplemental Life Insurance | Employee-Supplemental Life and AD&D - Employee Only |
0127 | Supplemental Life Insurance | Employee-Supplemental Life and AD&D - Employee Only |
0161 | Supplemental Life Insurance | Spouse-Supplemental Life and AD&D -Spouse Only |
0080 | Basic Life Insurance | Employee-Basic Term Life and AD&D |
0090 |
0127 |
0161 |