Merging cells with same ID in multiple rows
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHI
1
Output - data combined whenever the ID is the sameInput - data with various entries for the same ID
2
IDData 1Data 2Data 3IDData 1Data 2Data 3
3
YY02313xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M
4
YY02313xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M, 1xCat6 2M, 10xLWL OD SM 2M, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 3xDTR 2468 B8, 1xDTR 2242 B1B3, 2xDTR 2242 B1B3, 3xDTR 2217 B2018xHRDF 3m, 6xHRDF 5mYY02311xCat6 2M, 10xLWL OD SM 2M, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 3xDTR 2468 B8, 1xDTR 2242 B1B3, 2xDTR 2242 B1B3, 3xDTR 2217 B2018xHRDF 3m, 6xHRDF 5m
5
YY03111xCylinder, 1xOD 6340, 1xKey, 3xDTR holder (3), 1x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630
6
YY03111xCylinder, 1xOD 6340, 1xKey, 3xDTR holder (3), 1x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 11xLWL SM 5M, 3xSXK Rail, 11xLWL OD SM 5M, 1xCB 30A, 8x7/16 Cap IP68, 8x4.3-10 Cap IP68, 1xSubframe, 1xPDU - 20DC, 2xDTR 2217 B7, 2xDTR 2242 B1B3, 2xDTR 2242 B1B3, 1xSingle Pole1xMF SM (12) 30M, 1xFO SM (24), 2xGND Kit, 2xPTTA, 1xFTTA SM (36), 1xMF SM (24) 30M, 1x12x6mm 30M, 1x12x6mm 30M12xHMDF 3mYY031111xLWL SM 5M, 3xSXK Rail, 11xLWL OD SM 5M, 1xCB 30A, 8x7/16 Cap IP68, 8x4.3-10 Cap IP68, 1xSubframe, 1xPDU - 20DC, 2xDTR 2217 B7, 2xDTR 2242 B1B3, 2xDTR 2242 B1B3, 1xSingle Pole1xMF SM (12) 30M, 1xFO SM (24), 2xGND Kit, 2xPTTA, 1xFTTA SM (36), 1xMF SM (24) 30M, 1x12x6mm 30M, 1x12x6mm 30M12xHMDF 3m
7
YY12242xDTR holder (3), 1xRack 200, 1x2x6mm 100M, 1xDPE 6630
8
YY12242xDTR holder (3), 1xRack 200, 1x2x6mm 100M, 1xDPE 6630, 2xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B204xHRDF 5m, 8xHRDF 3mYY12242xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B204xHRDF 5m, 8xHRDF 3m
9
YY13722xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B20, 1xDPE 6630YY13721xDPE 6630
10
YY25541xRack 200, 3xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M
11
YY25541xRack 200, 3xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M, 3xLWL OD SM 2M, 1xCat6 10M, 2x4.3-10 Cap IP68, 1xPDU - 20DC, 1xDTR 2217 B20, 1xDTR 2242 B1B3, 1xDTR 2468 B82xHRDF 2m, 6xHRDF 3mYY25543xLWL OD SM 2M, 1xCat6 10M, 2x4.3-10 Cap IP68, 1xPDU - 20DC, 1xDTR 2217 B20, 1xDTR 2242 B1B3, 1xDTR 2468 B82xHRDF 2m, 6xHRDF 3m
12
YY27661xDPE 6630, 1x2x6mm 100M, 1xDTR holder (3)
13
YY27661xDPE 6630, 1x2x6mm 100M, 1xDTR holder (3), 1xDTR 2217 B7, 1xDTR 2212 B8, 2xCB 30A, 1xCat6 2M, 2xLWL OD SM 2M4xHRDM 3mYY27661xDTR 2217 B7, 1xDTR 2212 B8, 2xCB 30A, 1xCat6 2M, 2xLWL OD SM 2M4xHRDM 3m
14
YY29032x2x6mm 100M, 3xDTR holder (3), 1xDPE 6630, 1xDPE 6630
15
YY29032x2x6mm 100M, 3xDTR holder (3), 1xDPE 6630, 1xDPE 6630, 3xDTR 2212 B8, 2xDTR 2217 B7, 3xDTR 4415 B3, 1xDTR 2217 B7, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 3M, 9xLWL OD MM 5M, 3xLWL OD MM 2M, 12xLWL MM 2M, 3xSXK Rail8xHMDF 5m, 8xHMDF 4m, 20xHMDF 2mYY29033xDTR 2212 B8, 2xDTR 2217 B7, 3xDTR 4415 B3, 1xDTR 2217 B7, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 3M, 9xLWL OD MM 5M, 3xLWL OD MM 2M, 12xLWL MM 2M, 3xSXK Rail8xHMDF 5m, 8xHMDF 4m, 20xHMDF 2m
16
YY40461xCylinder, 1xKey, 1xOD 6340, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 1x2x6mm 100M
17
YY40461xCylinder, 1xKey, 1xOD 6340, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 1x2x6mm 100M, 2xDTR 2217 B20, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 2xCB 30A, 8xLWL OD SM 5M, 6xLWL OD SM 2M, 6xRET 1M, 4xSXK Rail, 4xDTR holder (2), 2xDTR 2468 B8, 2xDTR 2242 B1B3, 2xSingle Pole, 2xDTR 2242 B1B320xHMDF 4m, 8xHMHM 5m, 4xHMDF 5m, 4xHMHM 2mYY40462xDTR 2217 B20, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 2xCB 30A, 8xLWL OD SM 5M, 6xLWL OD SM 2M, 6xRET 1M, 4xSXK Rail, 4xDTR holder (2), 2xDTR 2468 B8, 2xDTR 2242 B1B3, 2xSingle Pole, 2xDTR 2242 B1B320xHMDF 4m, 8xHMHM 5m, 4xHMDF 5m, 4xHMHM 2m
18
YY44971xOD 6340, 1xCylinder, 1xKey, 1xDPE 6630, 4xDTR holder (3), 2x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630
19
YY44971xOD 6340, 1xCylinder, 1xKey, 1xDPE 6630, 4xDTR holder (3), 2x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 2xSingle Pole, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B7, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCB 30A, 12xLWL OD SM 10M, 9xLWL OD SM 5M, 4xSXK Rail6xHMDF 5m, 18xHMDF 3mYY44972xSingle Pole, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B7, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCB 30A, 12xLWL OD SM 10M, 9xLWL OD SM 5M, 4xSXK Rail6xHMDF 5m, 18xHMDF 3m
20
XX50192xDTR holder (3), 1xRack 200, 1xDPE 6630, 1x2x6mm 100M
21
XX50192xDTR holder (3), 1xRack 200, 1xDPE 6630, 1x2x6mm 100M, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 3M, 4xLWL OD SM 2M, 2xDTR 2468 B8, 2xDTR 2217 B20XX50198x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 3M, 4xLWL OD SM 2M, 2xDTR 2468 B8, 2xDTR 2217 B20
22
XX52834xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630
23
XX52834xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 2xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 10M, 21xLWL OD SM 2M, 21xLWL SM 5M, 2xRET 10M, 2xRET 5M, 2xRET 3M, 3xRET 2M, 4xSXK Rail, 1xDTR 2468 B8, 3xDTR 2217 B202xGND Kit, 2xPTTA, 2xFO SM (24), 2xFTTA SM (36), 2xMF SM (24) 50M, 1xMF SM (12) 50M, 1x12x6mm 50M, 1x12x6mm 50M16xHMHM 2m, 10xHMDM 2m, 8xHMDM 6m, 2xHMDM 3m, 2xHMHM 3m, 8xHMDM 5mXX52832xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 10M, 21xLWL OD SM 2M, 21xLWL SM 5M, 2xRET 10M, 2xRET 5M, 2xRET 3M, 3xRET 2M, 4xSXK Rail, 1xDTR 2468 B8, 3xDTR 2217 B202xGND Kit, 2xPTTA, 2xFO SM (24), 2xFTTA SM (36), 2xMF SM (24) 50M, 1xMF SM (12) 50M, 1x12x6mm 50M, 1x12x6mm 50M16xHMHM 2m, 10xHMDM 2m, 8xHMDM 6m, 2xHMDM 3m, 2xHMHM 3m, 8xHMDM 5m
24
XX52871xPadlock, 1xKey, 1xDPE 6630, 2x2x6mm 100M, 1x2x6mm 100M
25
XX52871xPadlock, 1xKey, 1xDPE 6630, 2x2x6mm 100M, 1x2x6mm 100M, 18xLWL SM 10M, 18xLWL OD SM 5M, 1xPDU - 20DC, 2xCB 30A, 6x4.3-10 Cap IP68, 3xRET 10M, 6xRET 5M, 3xSXK Rail, 3xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B31xMF SM (12) 50M, 2xMF SM (24) 50M, 2xFO SM (24), 1xPTTA, 3xGND Kit, 2xFTTA SM (36), 2xPTTA, 1x12x6mm 50M, 1x12x6mm 50M, 1x12x6mm 50M18xHMDM 4m, 16xHMDM 6m, 2xHMDM 7mXX528718xLWL SM 10M, 18xLWL OD SM 5M, 1xPDU - 20DC, 2xCB 30A, 6x4.3-10 Cap IP68, 3xRET 10M, 6xRET 5M, 3xSXK Rail, 3xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B31xMF SM (12) 50M, 2xMF SM (24) 50M, 2xFO SM (24), 1xPTTA, 3xGND Kit, 2xFTTA SM (36), 2xPTTA, 1x12x6mm 50M, 1x12x6mm 50M, 1x12x6mm 50M18xHMDM 4m, 16xHMDM 6m, 2xHMDM 7m
26
XX57501xRack 200, 2xDTR holder (3), 1xRack 200, 1xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M
27
XX57501xRack 200, 2xDTR holder (3), 1xRack 200, 1xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 1xPDU - 20DC, 1xCat6 10M, 1xLWL OD SM 10M, 6xLWL OD SM 2M, 1xDTR 2212 B814xHRDF 3mXX57503xDTR 2242 B1B3, 3xDTR 2242 B1B3, 1xPDU - 20DC, 1xCat6 10M, 1xLWL OD SM 10M, 6xLWL OD SM 2M, 1xDTR 2212 B814xHRDF 3m
28
XX57513xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M
29
XX57513xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 6xLWL OD SM 2M, 3xLWL OD SM 10M, 1xCat6 10M, 6xRET 1M, 1xPDU - 20DC6xHRDF 2m, 6xHRDF 3mXX57513xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 6xLWL OD SM 2M, 3xLWL OD SM 10M, 1xCat6 10M, 6xRET 1M, 1xPDU - 20DC6xHRDF 2m, 6xHRDF 3m
30
XX70801xDTR holder (3), 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M
31
XX70801xDTR holder (3), 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 6xLWL OD SM 10M, 12xLWL OD SM 2M, 3xRET 1M12xHRDF 3m, 6xHRDM 3mXX70803xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 6xLWL OD SM 10M, 12xLWL OD SM 2M, 3xRET 1M12xHRDF 3m, 6xHRDM 3m
32
XX74052xDTR holder (3), 1xRack 200, 2x2x6mm 100M, 1xDTR holder (3), 1xDPE 6630
33
2xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7mXX740512x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 3xLWL OD SM 10M, 3xLWL OD SM 5M, 3xLWL OD SM 2M, 6xLWL SM 2M, 2xRET 10M, 4xRET 5M, 2xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2468 B82xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7m
34
XX740512x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 3xLWL OD SM 10M, 3xLWL OD SM 5M, 3xLWL OD SM 2M, 6xLWL SM 2M, 2xRET 10M, 4xRET 5M, 2xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2468 B8, 2xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M1xMF SM (24) 60M12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7mXX74051xMF SM (24) 60M
35
XX75591xDPE 6630, 3xDTR holder (3), 2x2x6mm 100M
36
XX75591xDPE 6630, 3xDTR holder (3), 2x2x6mm 100M, 12x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 6xLWL OD MM 5M, 3xLWL OD MM 2M, 9xLWL MM 2M, 6xRET 5M, 3xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2468 B81xGND Kit, 1xPTTA, 1xFO MM (24), 1xFTTA MM (36), 1xMF MM (24) 50M, 1x12x6mm 50M8xHMDM 7m, 12xHMDF 2m, 4xHMDM 8mXX755912x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 6xLWL OD MM 5M, 3xLWL OD MM 2M, 9xLWL MM 2M, 6xRET 5M, 3xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2468 B81xGND Kit, 1xPTTA, 1xFO MM (24), 1xFTTA MM (36), 1xMF MM (24) 50M, 1x12x6mm 50M8xHMDM 7m, 12xHMDF 2m, 4xHMDM 8m
37
XX75653xDTR holder (3), 1xRack 200, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630
38
XX75653xDTR holder (3), 1xRack 200, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 12xLWL OD SM 5M, 9xLWL OD SM 2M, 6xRET 1M18xHRDF 2mXX75653xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 12xLWL OD SM 5M, 9xLWL OD SM 2M, 6xRET 1M18xHRDF 2m
39
XX75763xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M
40
XX75763xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2217 B20, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 9xRET 1M, 6xLWL OD SM 2M, 15xLWL OD SM 10M, 2xCat6 10M, 1xPDU - 20DC, 8x4.3-10 Cap IP68, 3xDTR 2468 B824xHRDF 2mXX75763xDTR 2217 B20, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 9xRET 1M, 6xLWL OD SM 2M, 15xLWL OD SM 10M, 2xCat6 10M, 1xPDU - 20DC, 8x4.3-10 Cap IP68, 3xDTR 2468 B824xHRDF 2m
41
12xHRDF 3m, 12xHRDF 5mXX77353xDTR 2242 B1B3, 3xDTR 2242 B1B3, 12xLWL OD SM 10M, 6xLWL OD SM 5M, 6xRET 1M, 2xCat6 3M, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 3xDTR 2468 B812xHRDF 3m, 12xHRDF 5m
42
XX77353xDTR 2242 B1B3, 3xDTR 2242 B1B3, 12xLWL OD SM 10M, 6xLWL OD SM 5M, 6xRET 1M, 2xCat6 3M, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 3xDTR 2468 B8, 1xRack 150, 2xDTR holder (3), 1xRack 150, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 663012xHRDF 3m, 12xHRDF 5mXX77351xRack 150, 2xDTR holder (3), 1xRack 150, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...