Hello,
I have a problem and I am hoping someone can help me. I have an excellist with some materials and quantities next to it. Now I need a list that if the quantity is two this material will be included as two lines in the list. I need this for printing labels. I have been cracking my brain but can't figure it out so I was hoping someone here could help me.
Thanks in advance!
Best regards,
Taco
I have a problem and I am hoping someone can help me. I have an excellist with some materials and quantities next to it. Now I need a list that if the quantity is two this material will be included as two lines in the list. I need this for printing labels. I have been cracking my brain but can't figure it out so I was hoping someone here could help me.
Thanks in advance!
Best regards,
Taco
MAKT.MATNR Material Number | MAKT.MAKTX Material Description (Short Text) | MARD.LABST Valuated Unrestricted-Use Stock | New list | |
R600201000 | EDC Outlet Cast Y piece Assembly | 1,00 | EDC Outlet Cast Y piece Assembly | |
R600201010 | Cast Return Bend + Thermow. Fitting Arr. | 3,00 | Cast Return Bend + Thermow. Fitting Arr. | |
R600201020 | Cast Return Bend Without Thermow. Fittin | 3,00 | Cast Return Bend + Thermow. Fitting Arr. | |
R600201030 | Impeller (GAD 3118C-19003-01 pos 14) | 1,00 | Cast Return Bend + Thermow. Fitting Arr. | |
R600201040 | Shaft short(GAD 3118C-19003-01 pos 21) | 1,00 | Cast Return Bend Without Thermow. Fittin | |
R600201060 | Impeller (GAD 311BB-19003-01 pos 14) | 1,00 | Cast Return Bend Without Thermow. Fittin | |
R600201070 | Shaft long(GAD 311BB-19003-01 pos 21) | 1,00 | Cast Return Bend Without Thermow. Fittin | |
R600201080 | Cast Pin R201A/B (1613FHA-9) | 2,00 | Impeller (GAD 3118C-19003-01 pos 14) | |
R600201090 | Cast Pin R201A/B (1613FHA-10) | 2,00 | Shaft short(GAD 3118C-19003-01 pos 21) | |
R600201100 | Cast Pin R201A/B (1613FHA-11) | 8,00 | Impeller (GAD 311BB-19003-01 pos 14) | |
R600201130 | Tub Support R201C (1249T/01-07) | 10,00 | Shaft long(GAD 311BB-19003-01 pos 21) | |
R600201110 | Cast Pin R201D (1623FHA-16) | 6,00 | Cast Pin R201A/B (1613FHA-9) | |
R600201120 | Washer R201D (1623FHA-20) | 6,00 | Cast Pin R201A/B (1613FHA-9) | |
R636815110 | Inducer Dickow NCLih 100/250 P0452B/C | 1,00 | etc etc…. | |
R636815100 | Waaier Dickow NCLih 100/250 P0452B/C | 1,00 | ||
R695731500 | Regelkl. HW9000 DN40 600Lbs RF STD 1.061 | 1,00 | ||
R688650300 | Revisieset tbv Adams terugsl. DN350/PN10 | 1,00 | ||
R030510000 | Pijp CuNi70/30 1" x 2.11mm x 6500mm | 520,00 | ||
R910891010 | Pressure controller FRS-520 10-30mBarg | 2,00 | ||
R060102050 | Pakking Gore-Tex DN50 PN16 GN501 | 0,00 | ||
R695741000 | Groth drukveiligheid 6" 150lbs CS/PTFE | 2,00 | ||
R695732250 | Sprinklerkl. GEFA/NORBRO DN100/PN16 | 16,00 | ||
R733501000 | Regelkl. CAMFLEX II 2" 150# Wafer CV53 | 0,00 | ||