I have a workbook that has employee info in sheet1. Sheet2 lists the employees dependents with corresponding employees social security number in column A. Some employees have multiple dependents listed in multiple rows. Is there a formula that I can use in sheet1 to list each dependent in column, F, G, H, etc.?
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
Sheet1
111-11-1111 | Smith | Jon | |||||||
222-22-2222 | Wilson | Dave | |||||||
333-33-3333 | Char | Jan | |||||||
444-44-4444 | Page | Chris |
<tbody>
</tbody>
Sheet2
111-11-1111 | Smith | Kim | |||||||
111-11-1111 | Smith | Syd | |||||||
111-11-1111 | Smith | Sandy | |||||||
222-22-2222 | Wilson | Jan | |||||||
333-33-3333 | Char | Sarah | |||||||
333-33-3333 | Char | Dave | |||||||
444-44-4444 | Page | Mike | |||||||
444-44-4444 | Page | Larry |
<tbody>
</tbody>