Hello,
I'm trying to take a list of items and components and create a heirarchical Bill of Materials from the data sample shown here. The total list will be for 12000+ rows.
<tbody>
A
B
C
D
E
1
Item Number
UOM
Component
Component UOM
Quantity
2
CPT001A
EA
FPM1010R
MS
0.19
3
CPT0002A...