Spreadsheet: 476167d1471641286-excel-power-query-can-it-do-what-i-need-ef-power-query-example-20160819
Sheet: Cleaned Manually & with Formula

Item No. | Rev | CLM | Description | Finish | Material | Material Spec. | Dimen. Spec. | Size | Units | Item QTY | Unit WT (kg) Total WT (kg) | Supplier | Part No./NSN | Remarks
6 ID ERMETO SUPPORT SLEEVE | B | 10818 | SUPPORT SLEEVE ERMETO FOR 6mm ID TUBE FOR THIN WALL METAL TUBE 5.8x14 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH06MSX | -
6 ID ERMETO SUPPORT SLEEVE | B | 10818 | SUPPORT SLEEVE ERMETO FOR 6mm ID TUBE FOR THIN WALL METAL TUBE 5.8x14 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH06MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 3 | 0.01&0.03 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 5 | 0.01&0.05 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 5 | 0.01&0.05 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 6 | 0.01&0.06 | ABC CORP. | VH07MSX | -
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN WALL METAL TUBE 6.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 6 | 0.01&0.06 | ABC CORP. | VH07MSX | -
8 ID ERMETO SUPPORT SLEEVE | B | 10820 | SUPPORT SLEEVE ERMETO FOR 8mm ID TUBE FOR THIN WALL METAL TUBE 7.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH08MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 1 | 0.01&0.01 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 3 | 0.01&0.03 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 5 | 0.01&0.05 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 5 | 0.01&0.05 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 9 | 0.01&0.09 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 9 | 0.01&0.09 | ABC CORP. | VH09MSX | -
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN WALL METAL TUBE 8.8x15.5 | - | BRASS/MS | DIN 17671 | DIN EN ISO 8434-1 | - | ea | 10 | 0.01&0.1 | ABC CORP. | VH09MSX | -
BLOCK CLAMP 10 OD HS2 | B | 10908 | BLOCK CLAMP ASSEMBLY HS2-HSB1 COMPLETE DN8 37x127x30[NAME] | - | POLYAMIDE | - | - | - | ea | 1 | 0.15&0.15 | ASSEMBLY | - | -
BLOCK CLAMP 10 OD HS2 | B | 10908 | BLOCK CLAMP ASSEMBLY HS2-HSB1 COMPLETE DN8 37x127x30[NAME] | - | POLYAMIDE | - | - | - | ea | 1 | 0.15&0.15 | ASSEMBLY | - | -
BLOCK CLAMP 12 OD FORM C | B | 10904 | BLOCK CLAMP ASSEMBLY FORM C COMPLETE DN10 37x27x30[NAME] | - | POLYAMIDE | - | - | - | ea | 1 | 0.1&0.1 | STAUFF | 112A PA DP-AS M W3 | -