nbendotron
New Member
- Joined
- Oct 11, 2012
- Messages
- 8
Hi,
I am trying to create a formula that will identify unique ID's and pull them into a list in one cell that shows each unique ID separated by semi colons.
Data Table
<tbody>
</tbody>
Output Table
<tbody>
</tbody>
The formula would return "John; Max" in B2, "Haviar" in B3, "Jess; Ron; Ben" in B4, and "Marco" in B5. I know this is difficult, but I appreciate anyone that tries, thanks
I am trying to create a formula that will identify unique ID's and pull them into a list in one cell that shows each unique ID separated by semi colons.
Data Table
ID | Name |
1 | John |
1 | John |
1 | Max |
2 | Haviar |
3 | Jess |
3 | Ron |
3 | Ben |
4 | Marco |
4 | Marco |
<tbody>
</tbody>
Output Table
ID | Formula |
1 | ??? |
2 | |
3 | |
4 |
<tbody>
</tbody>
The formula would return "John; Max" in B2, "Haviar" in B3, "Jess; Ron; Ben" in B4, and "Marco" in B5. I know this is difficult, but I appreciate anyone that tries, thanks