I have a data set that looks like this:
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
and I need to convert it to look like this:
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
Basically, I need to consolidate all of the values from Col2 into a single data element where the values in col1 are repeated. Been looking at a creative Vlookup combined with a concat but cannot figure it out. My dataset is about 6000 rows.
Col1 | Col2 |
a | sam |
b | sam |
c | sam |
d | sam |
e | sam |
f | sam |
g | sam |
a | bill |
b | bill |
d | bill |
g | bill |
h | bill |
d | dave |
e | dave |
f | dave |
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
and I need to convert it to look like this:
NewCol1 | NewCol2 |
a | sam|bill |
b | sam|bill |
c | sam |
d | sam|bill|dave |
e | sam|dave |
f | sam|dave |
h | bill |
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
Basically, I need to consolidate all of the values from Col2 into a single data element where the values in col1 are repeated. Been looking at a creative Vlookup combined with a concat but cannot figure it out. My dataset is about 6000 rows.