I have a sheet that looks like this:
<tbody>
</tbody>
I need to have one column in a second sheet that lists everything in ID 2 and ID3 so that I have this:
<tbody>
</tbody>
Is this possible? Would this be a VLOOKUP? I want to make sure that it only lists unique values - no duplicates.
First | Last | ID 1 | ID 2 | ID 2 |
Mark | Smith | 0005-123 | 0005-456 | 0005-789 |
John | Turner | 0005-234 | 0005-567 | 0005-8910 |
Mary | Richards | 0005-345 | 0005-678 | 0005-8911 |
<tbody>
</tbody>
I need to have one column in a second sheet that lists everything in ID 2 and ID3 so that I have this:
IDs |
0005-456 |
0005-567 |
0005-678 |
0005-789 |
0005-8910 |
0005-8911 |
<tbody>
</tbody>
Is this possible? Would this be a VLOOKUP? I want to make sure that it only lists unique values - no duplicates.