How do I accomplish this with a formula? I need the vlookup results to be concatenated into a single cell. Thanks.
<tbody>
</tbody>
Initial Table | Lookup Results | |||
Class | Name | Class | Name | |
Class1 | Bob | Class1 | Bob, Lily, Alice | |
Class2 | Jane | Class2 | Jane, David, Sara | |
Class3 | John | Class3 | John, Lucy | |
Class2 | David | Class4 | Sally, James | |
Class4 | Sally | |||
Class1 | Lily | |||
Class1 | Alice | |||
Class2 | Sara | |||
Class4 | James | |||
Class3 | Lucy |
<tbody>
</tbody>