Spreadsheet: 476167d1471641286-excel-power-query-can-it-do-what-i-need-ef-power-query-example-20160819
Sheet: PDF Converted Data

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 | ABC CORP. | VH06MSX | -
 |  |  |  |  |  |  |  |  |  |  | 0.01
6 ID ERMETO SUPPORT SLEEVE | B | 10818 | SUPPORT SLEEVE ERMETO FOR 6mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC CORP. | VH06MSX | -
 |  |  | WALL METAL TUBE 5.8x14 |  |  |  | 8434-1 |  |  |  |  | HANNIFIN CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 3 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.03
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 5 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.05
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 5 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.05
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 6 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.06
7 ID ERMETO SUPPORT SLEEVE | B | 10813 | SUPPORT SLEEVE ERMETO FOR 7mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 6 | 0.01 | ABC | VH07MSX | -
 |  |  | WALL METAL TUBE 6.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.06
8 ID ERMETO SUPPORT SLEEVE | B | 10820 | SUPPORT SLEEVE ERMETO FOR 8mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH08MSX | -
 |  |  | WALL METAL TUBE 7.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 1 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.01
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 3 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.03
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 5 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.05
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 5 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.05
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 9 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.09
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 9 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.09
9 ID ERMETO SUPPORT SLEEVE | B | 10829 | SUPPORT SLEEVE ERMETO FOR 9mm ID TUBE FOR THIN | - | BRASS/MS | DIN 17671 | DIN EN ISO | - | ea | 10 | 0.01 | ABC | VH09MSX | -
 |  |  | WALL METAL TUBE 8.8x15.5 |  |  |  | 8434-1 |  |  |  |  | CORP.
 |  |  |  |  |  |  |  |  |  |  | 0.1
BLOCK CLAMP 10 OD HS2 | B | 10908 | BLOCK CLAMP ASSEMBLY HS2-HSB1 COMPLETE DN8 | - | POLYAMIDE | - | - | - | ea | 1 | 0.15 | ASSEMBLY | - | -
 |  |  | 37x127x30[NAME] |  |  |  |  |  |  |  | 0.15
BLOCK CLAMP 10 OD HS2 | B | 10908 | BLOCK CLAMP ASSEMBLY HS2-HSB1 COMPLETE DN8 | - | POLYAMIDE | - | - | - | ea | 1 | 0.15 | ASSEMBLY | - | -
 |  |  | 37x127x30[NAME] |  |  |  |  |  |  |  | 0.15
BLOCK CLAMP 12 OD FORM C | B | 10904 | BLOCK CLAMP ASSEMBLY FORM C COMPLETE DN10 | - | POLYAMIDE | - | - | - | ea | 1 | 0.1 | STAUFF | 112A PA DP-AS | -
 |  |  | 37x27x30[NAME] |  |  |  |  |  |  |  |  |  | M W3
 |  |  |  |  |  |  |  |  |  |  | 0.1