Forum Discussion

Darin Pederson's avatar
Darin Pederson
Copper Contributor
Jun 14, 2018

Inserting blank rows after a group of common items

I am looking for a way to insert blank rows automatically after a common group of items.  Also, is there a way to automatically add the quantities of each group?  Example below:

MaterialDescriptionTotal
.090 5052.090 5052H3216.34
.120 A366Astm A1008 CRS476.80
.120 A366Astm A1008 CRS635.73
.120 A366Astm A1008 CRS423.82
.120 A366Astm A1008 CRS423.82
.188 X 2.0 X 2.0 ANGLE 6061T6 39.00
.188 X 2.0 X 2.0 ANGLE 6061T6 39.00
.190 X 24.20 X 57.325 39.00
.190 X 24.20 X 57.325 39.00
.375 X 1.25 X 18.90BAR SAWED78.00
.375 X 1.60 X 1.85 78.00
.375 X 19.325 X 24.20 39.00
.460 +/-.005 THICKMATERIAL ASTM A36 PLATE39.00
.625 X 19.325 X 24.20 39.00
.625 X 2.00 BAR 6061-T6511 78.00
.625 X 2.50 BAR 6061T6511 39.00
.625 X 2.50 BAR 6061T6511 39.00
excel
No RepliesBe the first to reply