hi, is there a way to concatenate the contents of multiple cells together depending on IF certain criteria?
EG we have "item names" in Column A and their corresponding "order codes" in Column B
So sometimes we can have a plug, but it has 3 different order codes.
Is there a Marco or Function that could concatenate the info so that there is just one entry for plug (in row A) and 1 cell (in Row B ) which contains the 3 order codes (separated by a semicolon)
EG we have thousands of lines to go through, but in amongst them would be:
<colgroup><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
We would really like all of that info on one single row =
<colgroup><col><col></colgroup><tbody>
</tbody>
EG we have "item names" in Column A and their corresponding "order codes" in Column B
So sometimes we can have a plug, but it has 3 different order codes.
Is there a Marco or Function that could concatenate the info so that there is just one entry for plug (in row A) and 1 cell (in Row B ) which contains the 3 order codes (separated by a semicolon)
EG we have thousands of lines to go through, but in amongst them would be:
<colgroup><col><col></colgroup><tbody>
</tbody>
Row A | Row B |
plug | A45563 |
plug | 12223333 |
plug | XYZ |
<colgroup><col><col></colgroup><tbody>
</tbody>
We would really like all of that info on one single row =
Row A | Row B |
plug | A45563;12223333;XYZ |
<colgroup><col><col></colgroup><tbody>
</tbody>