In their wisdom my company wants the Cut List and the BOM to list all the same size items of a weldment to be listed as one item number on the Cut List & BOM with an acumulative length in just one row. I'd be happy if this could just be accompolished at least in the BOM.

All I can get is as below (Cut List shown 1st). I've tried "sort" to at least get each material size sorted together but I can't get sort to do anything. Whatever order I chose the Cut List & BOM stay exactly the same.

For instance I'd like Item 1 to read 90 x 90 x 8 RSA with the quanity being the total number of instances of the item and the total length to be the, as it says total length. All this grouped together in just one row. Is this possible?