Column A has multiple Cust parts. I need to separate the Cust part to individual rows with the other data in the columns matched.
Here is an example of the first row as it should appear:
Here is my data:
Here is an example of the first row as it should appear:
Excel 2010 | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
1 | Cust part | Our parts | Our ID | Currency | Price | ||
2 | 135649A1 | Part AD | 100110399 | USD | $ 18.95 | ||
3 | A75262 | Part AD | 100110399 | USD | $ 18.95 | ||
Example |
Here is my data:
Excel 2010 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Cust part | Our parts | Our ID | Currency | Price | ||
2 | 135649A1, A75262 | Part AD | 100110399 | USD | $18.95 | ||
3 | 138642, BN98510, 190585R91 | Part O | 100027144 | USD | $ 7.82 | ||
4 | 163044, BN98509 | Part W | 100026523 | USD | $ 4.57 | ||
5 | 179080, BSET2 | Part U | 100045902 | USD | $ 3.97 | ||
6 | 18427, ST791 | Part P | 100047915 | USD | $ 7.82 | ||
7 | 21076D, E3NN3123AA, 210760 | Part N | 100050683 | USD | $ 3.66 | ||
8 | 44401, 694735 CONE, ST775A | Part C | 100055719 | USD | $ 6.44 | ||
9 | 459456R91, 86576982 - CONE, 273423 | Part L | 100096658 | USD | $ 3.83 | ||
10 | 47508360, 52443, 664175R92 | Part F | 100081326 | USD | $13.22 | ||
Example |