Grouping BOM Components by Unique Column

[ltkenbo]

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:

[TABLE="width: 200"]
<tbody>[TR]
[TD]Component[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]11111111[/TD]
[/TR]
[TR]
[TD]C2[/TD]
[TD]11111111[/TD]
[/TR]
[TR]
[TD]R1[/TD]
[TD]22222222[/TD]
[/TR]
[TR]
[TD]R2[/TD]
[TD]22222222[/TD]
[/TR]
[TR]
[TD]R3[/TD]
[TD]33333333[/TD]
[/TR]
[TR]
[TD]U1[/TD]
[TD]44444444[/TD]
[/TR]
[TR]
[TD]U2[/TD]
[TD]44444444[/TD]
[/TR]
</tbody>[/TABLE]


I would like the result to group components together by unique part numbers, like the following:

[TABLE="width: 100"]
<tbody>[TR]
[TD]Component[/TD]
[TD]Part Number[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]C1, C2[/TD]
[TD]11111111[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]R1, R2[/TD]
[TD]22222222[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]R3[/TD]
[TD]33333333[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]U1, U2[/TD]
[TD]44444444[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

What would be the easiest way to do this?

 

[FDibbins]

Hi, welcome to the board

You could kinda do this with a quick Pivot Table...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][/tr]
[tr][td]

1​

[/td][td]Component[/td][td]Part Number[/td][td][/td][td]Row Labels[/td][td]Count of Component[/td][/tr]

[tr][td]

2​

[/td][td]C1[/td][td]11111111[/td][td][/td][td]11111111[/td][td]

2​

[/td][/tr]

[tr][td]

3​

[/td][td]C2[/td][td]11111111[/td][td][/td][td]C1[/td][td]

1​

[/td][/tr]

[tr][td]

4​

[/td][td]R1[/td][td]22222222[/td][td][/td][td]C2[/td][td]

1​

[/td][/tr]

[tr][td]

5​

[/td][td]R2[/td][td]22222222[/td][td][/td][td]22222222[/td][td]

2​

[/td][/tr]

[tr][td]

6​

[/td][td]R3[/td][td]33333333[/td][td][/td][td]R1[/td][td]

1​

[/td][/tr]

[tr][td]

7​

[/td][td]U1[/td][td]44444444[/td][td][/td][td]R2[/td][td]

1​

[/td][/tr]

[tr][td]

8​

[/td][td]U2[/td][td]44444444[/td][td][/td][td]33333333[/td][td]

1​

[/td][/tr]

[tr][td]

9​

[/td][td][/td][td][/td][td][/td][td]R3[/td][td]

1​

[/td][/tr]

[tr][td]

10​

[/td][td][/td][td][/td][td][/td][td]44444444[/td][td]

2​

[/td][/tr]

[tr][td]

11​

[/td][td][/td][td][/td][td][/td][td]U1[/td][td]

1​

[/td][/tr]

[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td]U2[/td][td]

1​

[/td][/tr]

[tr][td]

13​

[/td][td][/td][td][/td][td][/td][td]Grand Total[/td][td]

7​

[/td][/tr]
[/table]

Highlight the data
Insert Tab/Pivot Table
Put Part Number and then Components (in that order) in the Row labels window
Put Components in Values