I'm looking for a way to group BOM components for an electronics BOM. Currently my program outputs a CSV table like this for example:
<tbody>
</tbody>
I would like the result to group components together by unique part numbers, like the following:
<tbody>
</tbody>
What would be the easiest way to do this?
Component | Part Number |
C1 | 11111111 |
C2 | 11111111 |
R1 | 22222222 |
R2 | 22222222 |
R3 | 33333333 |
U1 | 44444444 |
U2 | 44444444 |
<tbody>
</tbody>
I would like the result to group components together by unique part numbers, like the following:
Component | Part Number | Quantity |
C1, C2 | 11111111 | 2 |
R1, R2 | 22222222 | 2 |
R3 | 33333333 | 1 |
U1, U2 | 44444444 | 2 |
<tbody>
</tbody>
What would be the easiest way to do this?