I'm try to generate a P/N in column A for each combination associated with the categories. Cat 1 will always be a constant, but then the P/N should reflect (in order) Cat 2 (c2), Cat 3 (D2), Cat 4( d2), then start all over again in order to list all combinations. There should also be a second column (description) that generates the description associated with each selection.
Any help would be greatly appreciated. This is only the first table of about 10 that I need to complete.
Thanks so much!
ewOOD
<tbody>
</tbody>
<tbody>
</tbody>
Any help would be greatly appreciated. This is only the first table of about 10 that I need to complete.
Thanks so much!
ewOOD
P/N | Description | CAT 1 | CAT 2 | CAT 3 | CAT 4 | CAT 5 | Category | Part Code | Part Description |
BF1811 | BAR FLAT 1/8" 1" L/C | B | F | 18 | 1 | 1 | 01 | B | BAR |
BF1812 | R | 14 | 112 | 2 | 02 | F | FLAT | ||
BF1813 | S | 38 | 2 | 3 | 02 | R | ROUND | ||
H | 12 | 212 | 02 | S | SQUARE | ||||
58 | 3 | 02 | H | HEX | |||||
114 | 4 | 03 | 18 | 1/8" | |||||
112 | 6 | 03 | 14 | 1/4" | |||||
2 | 34 | 03 | 38 | 3/8" | |||||
212 | 114 | 03 | 12 | 1/2" | |||||
3 | 312 | 03 | 58 | 5/8" | |||||
312 | 12 | 03 | 114 | 1-1/4" | |||||
4 | 58 | 03 | 112 | 1-1/2" | |||||
6 | 03 | 2 | 2" | ||||||
618 | 03 | 212 | 2-1/2" | ||||||
8 | 03 | 3 | 3" | ||||||
5 | 03 | 312 | 3-1/2" | ||||||
512 | 03 | 4 | 4" | ||||||
03 | 6 | 6" | |||||||
03 | 618 | 6-1/8" | |||||||
03 | 8 | 8" | |||||||
03 | 5 | 5" | |||||||
03 | 512 | 5-1/2" | |||||||
04 | 1 | 1" | |||||||
04 | 112 | 1-1/2" | |||||||
04 | 2 | 2" | |||||||
04 | 212 | 2-1/2" | |||||||
04 | 3 | 3" | |||||||
04 | 4 | 4" | |||||||
04 | 6 | 6" | |||||||
04 | 34 | 3/4" | |||||||
04 | 114 | 1-1/4" | |||||||
04 | 312 | 3-1/2" | |||||||
04 | 12 | 1/2" | |||||||
04 | 58 | 5/8" | |||||||
05 | 1 | L/C | |||||||
05 | 2 | 304L | |||||||
05 | 3 | 316L |
<tbody>
</tbody>
<tbody>
</tbody>