M
Morton Detwyler
I have a matrix of data that lists part numbers in row [1] and serial numbers
in column [A] as shown in Example 1. In the example below (Example 1), the
range beginning in cell [B2] and ending in cell [H6], is the number of days
from that serial number's manufacturing date that a part was replaced; i.e.
Serial # 12A had PART2 replaced 528 days after 12A's manufacture.
Leaving the data in Example 1 intact, I need to create another matrix to
summarize the data as displayed in Example 2. Where per serial number, the
parts that have a "0" are eliminated, and I'm left with only the parts that
have been consumed and the elapsed days from manufacturing.
Is there any way possible of doing this?
Thanks so much for your time and assistance.
EXAMPLE 1
¯¯¯¯¯¯¯¯¯¯
COL/ROW [C] [D] [E] [F] [G]
[H]
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
[1] Serial # PART1 PART2 PART3 PART4 PART5 PART6 PART7
[2] 12A 0 528 0 0 528 0
528
[3] 23B 0 497 157 0 497 0
497
[4] 34C 465 430 0 0 0 0
0
[5] 45D 0 378 0 398 0 0
0
[6] 56E 0 373 0 0 373 0
0
EXAMPLE 2
¯¯¯¯¯¯¯¯¯¯
Serial # PART2 PART5 PART7
12A 528 528 528
Serial # PART2 PART3 PART5 PART7
23B 497 157 497 497
Serial # PART1 PART2
34C 465 430
Serial # PART2 PART4
45D 378 398
Serial # PART2 PART5
56E 373 373
in column [A] as shown in Example 1. In the example below (Example 1), the
range beginning in cell [B2] and ending in cell [H6], is the number of days
from that serial number's manufacturing date that a part was replaced; i.e.
Serial # 12A had PART2 replaced 528 days after 12A's manufacture.
Leaving the data in Example 1 intact, I need to create another matrix to
summarize the data as displayed in Example 2. Where per serial number, the
parts that have a "0" are eliminated, and I'm left with only the parts that
have been consumed and the elapsed days from manufacturing.
Is there any way possible of doing this?
Thanks so much for your time and assistance.
EXAMPLE 1
¯¯¯¯¯¯¯¯¯¯
COL/ROW [C] [D] [E] [F] [G]
[H]
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
[1] Serial # PART1 PART2 PART3 PART4 PART5 PART6 PART7
[2] 12A 0 528 0 0 528 0
528
[3] 23B 0 497 157 0 497 0
497
[4] 34C 465 430 0 0 0 0
0
[5] 45D 0 378 0 398 0 0
0
[6] 56E 0 373 0 0 373 0
0
EXAMPLE 2
¯¯¯¯¯¯¯¯¯¯
Serial # PART2 PART5 PART7
12A 528 528 528
Serial # PART2 PART3 PART5 PART7
23B 497 157 497 497
Serial # PART1 PART2
34C 465 430
Serial # PART2 PART4
45D 378 398
Serial # PART2 PART5
56E 373 373