combine multiple rows to one row with blanks in some reference columns

J

JSWAIN

New Member
Joined
Jun 4, 2014
Messages
5
Hi, I scanned several other posts that deal with combining multiple rows of related data into one row but have not seen one that matches my situation. My experience level with excel only includes some basics like vlookup, match and recorded macros, although I have used vba code for a macro that was written by someone else where it met my needs.
I have a parts list for a PCB that has many different parts. Some of the parts are used multiple times across different reference designations("Reference" column in the file). I have shown a desired format and the original format below. Since the item number has blanks across the reference designators I haven't found a solution that would work for me. Any help would be appreciated.


Desired output:
[TABLE="width: 513"]
<COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1097" width=30><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 283pt; mso-width-source: userset; mso-width-alt: 13787" width=377><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1499" width=41><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" width=54><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><TBODY>[TR]
[TD="class: xl65, width: 30, bgcolor: #c5d9f1"]Item[/TD]
[TD="class: xl65, width: 50, bgcolor: #c5d9f1"]Quantity[/TD]
[TD="class: xl66, width: 377, bgcolor: #c5d9f1"]Reference[/TD]
[TD="class: xl67, width: 41, bgcolor: #c5d9f1"]Value[/TD]
[TD="class: xl65, width: 66, bgcolor: #c5d9f1"]TOLERANCE[/TD]
[TD="class: xl65, width: 54, bgcolor: #c5d9f1"]VOLTAGE[/TD]
[TD="class: xl65, width: 62, bgcolor: #c5d9f1"]Internal PN[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]1[/TD]
[TD="class: xl68, bgcolor: transparent"]18[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39[/TD]
[TD="class: xl70, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl71, bgcolor: transparent"]10%[/TD]
[TD="class: xl68, bgcolor: transparent"]25V[/TD]
[TD="class: xl68, bgcolor: transparent"]123456[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]2[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD="class: xl70, bgcolor: transparent"]150pF[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"]500V[/TD]
[TD="class: xl68, bgcolor: transparent"]123457[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]3[/TD]
[TD="class: xl68, bgcolor: transparent"]4[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl70, bgcolor: transparent"]150pF[/TD]
[TD="class: xl71, bgcolor: transparent"]5%[/TD]
[TD="class: xl68, bgcolor: transparent"]50V[/TD]
[TD="class: xl68, bgcolor: transparent"]123458[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]4[/TD]
[TD="class: xl68, bgcolor: transparent"]7[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD="class: xl70, bgcolor: transparent"]150pF[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"]50V[/TD]
[TD="class: xl68, bgcolor: transparent"]123459[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]5[/TD]
[TD="class: xl68, bgcolor: transparent"]3[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C43,C139,C144[/TD]
[TD="class: xl70, bgcolor: transparent"]22pF[/TD]
[TD="class: xl71, bgcolor: transparent"]5%[/TD]
[TD="class: xl68, bgcolor: transparent"]200V[/TD]
[TD="class: xl68, bgcolor: transparent"]123460[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]6[/TD]
[TD="class: xl68, bgcolor: transparent"]1[/TD]
[TD="class: xl69, width: 377, bgcolor: transparent"]C44[/TD]
[TD="class: xl70, bgcolor: transparent"]820pF[/TD]
[TD="class: xl71, bgcolor: transparent"]5%[/TD]
[TD="class: xl68, bgcolor: transparent"]50V[/TD]
[TD="class: xl68, bgcolor: transparent"]123461[/TD]
[/TR]
</TBODY>[/TABLE]



Original output:
[TABLE="width: 445"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" width=98><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY>[TR]
[TD="class: xl68, width: 64, bgcolor: #c5d9f1"]Item[/TD]
[TD="class: xl68, width: 64, bgcolor: #c5d9f1"]Quantity[/TD]
[TD="class: xl69, width: 135, bgcolor: #c5d9f1"]Reference[/TD]
[TD="class: xl70, width: 51, bgcolor: #c5d9f1"]Value[/TD]
[TD="class: xl68, width: 98, bgcolor: #c5d9f1"]TOLERANCE[/TD]
[TD="class: xl68, width: 86, bgcolor: #c5d9f1"]VOLTAGE[/TD]
[TD="class: xl68, width: 94, bgcolor: #c5d9f1"]Internal PN[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"]18[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,[/TD]
[TD="class: xl73, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl74, bgcolor: transparent"]10%[/TD]
[TD="class: xl71, bgcolor: transparent"]25V[/TD]
[TD="class: xl71, bgcolor: transparent"]123456[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C14,C15,C18,C21,C22,C25,[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C28,C29,C32,C37,C38,C39,[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"]10[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,[/TD]
[TD="class: xl73, bgcolor: transparent"]150pF[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"]500V[/TD]
[TD="class: xl71, bgcolor: transparent"]123457[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C26,C30,C33,C35[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl71, bgcolor: transparent"]4[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl73, bgcolor: transparent"]150pF[/TD]
[TD="class: xl74, bgcolor: transparent"]5%[/TD]
[TD="class: xl71, bgcolor: transparent"]50V[/TD]
[TD="class: xl71, bgcolor: transparent"]123458[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]4[/TD]
[TD="class: xl71, bgcolor: transparent"]7[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,[/TD]
[TD="class: xl73, bgcolor: transparent"]150pF[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"]50V[/TD]
[TD="class: xl71, bgcolor: transparent"]123459[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C36[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]5[/TD]
[TD="class: xl71, bgcolor: transparent"]3[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C43,C139,C144[/TD]
[TD="class: xl73, bgcolor: transparent"]22pF[/TD]
[TD="class: xl74, bgcolor: transparent"]5%[/TD]
[TD="class: xl71, bgcolor: transparent"]200V[/TD]
[TD="class: xl71, bgcolor: transparent"]123460[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6[/TD]
[TD="class: xl71, bgcolor: transparent"]1[/TD]
[TD="class: xl72, width: 135, bgcolor: transparent"]C44[/TD]
[TD="class: xl73, bgcolor: transparent"]820pF[/TD]
[TD="class: xl74, bgcolor: transparent"]5%[/TD]
[TD="class: xl71, bgcolor: transparent"]50V[/TD]
[TD="class: xl71, bgcolor: transparent"]123461[/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sort by date Sort by votes
[TABLE="width: 967"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item[/TD]
[TD]Quantity[/TD]
[TD]Reference[/TD]
[TD]Value[/TD]
[TD]TOLERANCE[/TD]
[TD]VOLTAGE[/TD]
[TD]Internal PN[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]18[/TD]
[TD]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39[/TD]
[TD]0.10uF[/TD]
[TD="align: right"]10%[/TD]
[TD]25V[/TD]
[TD="align: right"]123456[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD]150pF[/TD]
[TD] [/TD]
[TD]500V[/TD]
[TD="align: right"]123457[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]C6,C10,C12,C445[/TD]
[TD]150pF[/TD]
[TD="align: right"]5%[/TD]
[TD]50V[/TD]
[TD="align: right"]123458[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD]150pF[/TD]
[TD] [/TD]
[TD]50V[/TD]
[TD="align: right"]123459[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD]C43,C139,C144[/TD]
[TD]22pF[/TD]
[TD="align: right"]5%[/TD]
[TD]200V[/TD]
[TD="align: right"]123460[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD]C44[/TD]
[TD]820pF[/TD]
[TD="align: right"]5%[/TD]
[TD]50V[/TD]
[TD="align: right"]12346[/TD]
[/TR]
[TR]
[TD]Item[/TD]
[TD]Quantity[/TD]
[TD]Reference[/TD]
[TD]Value[/TD]
[TD]TOLERANCE[/TD]
[TD]VOLTAGE[/TD]
[TD]Internal PN[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]18[/TD]
[TD]C1,C2,C3,C4,C7,C8,C1[/TD]
[TD]0.10uF[/TD]
[TD="align: right"]10%[/TD]
[TD]25V[/TD]
[TD="align: right"]123456[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD],C29,C32,C37,C38,C39[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD],C14,C15,C18,C21,C22,C25,C28,[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Couldnt come up with a more elegant code

Please try this on a sample of the data

Code: 
Sub ConcatCells()
    Dim wf As WorksheetFunction, r
    
    Set wf = Application.WorksheetFunction
    
    I = 2
    lC = Range("XFD1").End(xlToLeft).Column
    LRow = Range("A" & Rows.Count).End(xlUp).Row
    Do
        LR = wf.Min(Range("A" & I).End(xlDown).Row, LRow)
        
        For J = I + 1 To LR - 1
            For K = 1 To lC
                Cells(I, K) = Cells(I, K) & Cells(J, K)
            Next K
        Next J
        
    I = LR
    Loop Until LR = Range("A" & Rows.Count).End(xlUp).Row
    
    'delete blank rows - Filter and delete would achieve same thing
    For L = LRow To 1 Step -1
        If Cells(L, "A") = "" Then
            Rows(L).EntireRow.Delete
        End If
    Next L
    
End Sub
 
Upvote 0
Thanks, Momentman, that worked on the first few lines but then the data got jumbled after line 4. It seems to combine more than just the refernce designators. I also did it on the full set of data and similar errors occur occasionally after that, but not on every line. Here is the result after using your macro. I hope it is viewable:
[TABLE="width: 454"]
<COLGROUP><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1389" width=38><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 147pt; mso-width-source: userset; mso-width-alt: 7168" width=196><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="class: xl67, width: 38, bgcolor: transparent"]Item[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]Reference[/TD]
[TD="class: xl67, width: 69, bgcolor: transparent"]Part[/TD]
[TD="class: xl67, width: 80, bgcolor: transparent"]TOLERANCE[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]VOLTAGE[/TD]
[TD="class: xl67, width: 95, bgcolor: transparent"]INTERNAL P.N.[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]186[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39,C40,C41,C42,C45,C46,C50,C51,C52,C56,C58,C59,C62,C63,C64,C68,C72,C73,C74,C78,C82,C83,C84,C88,C92,C93,C94,C98,C102,C103,C104,C108,C112,C113,C114,C118,C122,C123,C124,C128,C129,C130,C131,C133,C135,C138,C142,C143,C145,C149,C151,C154,C156,C158,C161,C162,C164,C166,C167,C169,C170,C171,C172,C173,C174,C175,C180,C197,C198,C203,C207,C208,C212,C213,C217,C218,C219,C220,C221,C222,C223,C226,C227,C229,C230,C232,C233,C255,C257,C258,C259,C262,C265,C266,C269,C270,C273,C274,C276,C279,C280,C281,C282,C283,C286,C287,C288,C290,C291,C292,C294,C295,C296,C298,C301,C302,C303,C304,C305,C307,C312,C314,C316,C317,C318,C319,C320,C321,C322,C323,C328,C345,C346,C351,C355,C356,C360,C361,C365,C366,C367,C368,C369,C370,C371,C374,C375,C377,C378,C380,C381,C403,C408,C409,C410,C412,C413,C418,C419,C425,C427,C428,C429,C430,C507,C508,C521, C525[/TD]
[TD="class: xl67, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.1[/TD]
[TD="class: xl67, bgcolor: transparent"]25V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]123456[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]500V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]123457[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]123458[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]123459[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]56[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]31[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C43,C139,C144C44[/TD]
[TD="class: xl67, bgcolor: transparent"]22pF820pF[/TD]
[TD="class: xl67, bgcolor: transparent"]0.050.05[/TD]
[TD="class: xl67, bgcolor: transparent"]200V50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]1.2346E+11[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, width: 196, bgcolor: transparent"]C44[/TD]
[TD="class: xl67, bgcolor: transparent"]820pF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]123461[/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
I ran the code on the sample data and it gives exactly the output you posted. Maybe Post the new sample data you ran it on, so I can test with that
 
Upvote 0
Momentman, I tried again on the basic sample and it did work, not sure what I may have done wrong before. However, it still is not working with the whole file.
Here is a portion of the original file with the first 7 lines. It runs fine when I run the macro with only the first 6 lines, but when I run it on 7 items, I get the error.
The only difference between this and the original sample data is that our internal PNs can be a mix(alphanumeric), but that doesn't seem to make a difference with the macro as the first line is alphanumeric.

Original data with 7 items:
[TABLE="width: 417"]
<COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6400" width=175><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY>[TR]
[TD="class: xl65, width: 36, bgcolor: transparent"]Item[/TD]
[TD="class: xl65, width: 61, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl65, width: 175, bgcolor: transparent"]Reference[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Part[/TD]
[TD="class: xl65, width: 79, bgcolor: transparent"]TOLERANCE[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]VOLTAGE[/TD]
[TD="class: xl65, width: 94, bgcolor: transparent"]INTERNAL P.N.[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]186[/TD]
[TD="class: xl65, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,[/TD]
[TD="class: xl65, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.1[/TD]
[TD="class: xl65, bgcolor: transparent"]25V[/TD]
[TD="class: xl65, bgcolor: transparent"]MS30797[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C14,C15,C18,C21,C22,C25,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C28,C29,C32,C37,C38,C39,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C40,C41,C42,C45,C46,C50,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C51,C52,C56,C58,C59,C62,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C63,C64,C68,C72,C73,C74,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C78,C82,C83,C84,C88,C92,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C93,C94,C98,C102,C103,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C104,C108,C112,C113,C114,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C118,C122,C123,C124,C128,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C129,C130,C131,C133,C135,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C138,C142,C143,C145,C149,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C151,C154,C156,C158,C161,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C162,C164,C166,C167,C169,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C170,C171,C172,C173,C174,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C175,C180,C197,C198,C203,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C207,C208,C212,C213,C217,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C218,C219,C220,C221,C222,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C223,C226,C227,C229,C230,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C232,C233,C255,C257,C258,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C259,C262,C265,C266,C269,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C270,C273,C274,C276,C279,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C280,C281,C282,C283,C286,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C287,C288,C290,C291,C292,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C294,C295,C296,C298,C301,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C302,C303,C304,C305,C307,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C312,C314,C316,C317,C318,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C319,C320,C321,C322,C323,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C328,C345,C346,C351,C355,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C356,C360,C361,C365,C366,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C367,C368,C369,C370,C371,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C374,C375,C377,C378,C380,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C381,C403,C408,C409,C410,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C412,C413,C418,C419,C425,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C427,C428,C429,C430,C507,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C508,C521, C525[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl65, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]500V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5595926[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C26,C30,C33,C35[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C36[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent"]C43,C139,C144[/TD]
[TD="class: xl65, bgcolor: transparent"]22pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"]200V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4711425[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"]C44[/TD]
[TD="class: xl65, bgcolor: transparent"]820pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3379299[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl65, bgcolor: transparent"]C47,C57,C69,C79,C89,C99,[/TD]
[TD="class: xl65, bgcolor: transparent"]330pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]7752603[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C109,C119,C267,C271,C272,[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]C293,C299[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]


Results of running macro on first 6 lines(note: I wrapped the text on the 186 so that it might show better:
[TABLE="width: 417"]
<COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6400" width=175><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY>[TR]
[TD="class: xl66, width: 36, bgcolor: transparent"]Item[/TD]
[TD="class: xl66, width: 61, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]Reference[/TD]
[TD="class: xl66, width: 47, bgcolor: transparent"]Part[/TD]
[TD="class: xl66, width: 79, bgcolor: transparent"]TOLERANCE[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]VOLTAGE[/TD]
[TD="class: xl66, width: 94, bgcolor: transparent"]INTERNAL P.N.[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]186[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39,C40,C41,C42,C45,C46,C50,C51,C52,C56,C58,C59,C62,C63,C64,C68,C72,C73,C74,C78,C82,C83,C84,C88,C92,C93,C94,C98,C102,C103,C104,C108,C112,C113,C114,C118,C122,C123,C124,C128,C129,C130,C131,C133,C135,C138,C142,C143,C145,C149,C151,C154,C156,C158,C161,C162,C164,C166,C167,C169,C170,C171,C172,C173,C174,C175,C180,C197,C198,C203,C207,C208,C212,C213,C217,C218,C219,C220,C221,C222,C223,C226,C227,C229,C230,C232,C233,C255,C257,C258,C259,C262,C265,C266,C269,C270,C273,C274,C276,C279,C280,C281,C282,C283,C286,C287,C288,C290,C291,C292,C294,C295,C296,C298,C301,C302,C303,C304,C305,C307,C312,C314,C316,C317,C318,C319,C320,C321,C322,C323,C328,C345,C346,C351,C355,C356,C360,C361,C365,C366,C367,C368,C369,C370,C371,C374,C375,C377,C378,C380,C381,C403,C408,C409,C410,C412,C413,C418,C419,C425,C427,C428,C429,C430,C507,C508,C521, C525[/TD]
[TD="class: xl66, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.1[/TD]
[TD="class: xl66, bgcolor: transparent"]25V[/TD]
[TD="class: xl66, bgcolor: transparent"]MS30797[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD="class: xl66, bgcolor: transparent"]150pF[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]500V[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5595926[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl66, bgcolor: transparent"]150pF[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl66, bgcolor: transparent"]50V[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD="class: xl66, bgcolor: transparent"]150pF[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]50V[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C43,C139,C144[/TD]
[TD="class: xl66, bgcolor: transparent"]22pF[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl66, bgcolor: transparent"]200V[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4711425[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"]C44[/TD]
[TD="class: xl66, bgcolor: transparent"]820pF[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl66, bgcolor: transparent"]50V[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]3379299[/TD]
[/TR]
</TBODY>[/TABLE]


Results after running macro on 7 lines(wrapped text after macro again:
[TABLE="width: 417"]
<COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6400" width=175><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY>[TR]
[TD="class: xl67, width: 36, bgcolor: transparent"]Item[/TD]
[TD="class: xl67, width: 61, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]Reference[/TD]
[TD="class: xl67, width: 47, bgcolor: transparent"]Part[/TD]
[TD="class: xl67, width: 79, bgcolor: transparent"]TOLERANCE[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]VOLTAGE[/TD]
[TD="class: xl67, width: 94, bgcolor: transparent"]INTERNAL P.N.[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]186[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39,C40,C41,C42,C45,C46,C50,C51,C52,C56,C58,C59,C62,C63,C64,C68,C72,C73,C74,C78,C82,C83,C84,C88,C92,C93,C94,C98,C102,C103,C104,C108,C112,C113,C114,C118,C122,C123,C124,C128,C129,C130,C131,C133,C135,C138,C142,C143,C145,C149,C151,C154,C156,C158,C161,C162,C164,C166,C167,C169,C170,C171,C172,C173,C174,C175,C180,C197,C198,C203,C207,C208,C212,C213,C217,C218,C219,C220,C221,C222,C223,C226,C227,C229,C230,C232,C233,C255,C257,C258,C259,C262,C265,C266,C269,C270,C273,C274,C276,C279,C280,C281,C282,C283,C286,C287,C288,C290,C291,C292,C294,C295,C296,C298,C301,C302,C303,C304,C305,C307,C312,C314,C316,C317,C318,C319,C320,C321,C322,C323,C328,C345,C346,C351,C355,C356,C360,C361,C365,C366,C367,C368,C369,C370,C371,C374,C375,C377,C378,C380,C381,C403,C408,C409,C410,C412,C413,C418,C419,C425,C427,C428,C429,C430,C507,C508,C521, C525[/TD]
[TD="class: xl67, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.1[/TD]
[TD="class: xl67, bgcolor: transparent"]25V[/TD]
[TD="class: xl67, bgcolor: transparent"]MS30797[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]500V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]5595926[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD="class: xl67, bgcolor: transparent"]150pF[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]56[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]31[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C43,C139,C144C44[/TD]
[TD="class: xl67, bgcolor: transparent"]22pF820pF[/TD]
[TD="class: xl67, bgcolor: transparent"]0.050.05[/TD]
[TD="class: xl67, bgcolor: transparent"]200V50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]4.71143E+13[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C44[/TD]
[TD="class: xl67, bgcolor: transparent"]820pF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl67, bgcolor: transparent"]50V[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]3379299[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C47,C57,C69,C79,C89,C99,[/TD]
[TD="class: xl67, bgcolor: transparent"]330pF[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]7752603[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C109,C119,C267,C271,C272,[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 175, bgcolor: transparent"]C293,C299[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]
















 
Upvote 0
I seem to have spotted the problem, My macro assume(d) that the very last line of data is in column A, which for your data is wrong 'cos the last line of data is seen from Column C and i think Column C is more accurate than using any other columns. So, I have revised the code

PLEASE TRY ON A COPY OF THE DATA
Code: 
Sub ConcatCells()
    Dim wf As WorksheetFunction, r
    
    Set wf = Application.WorksheetFunction
    
    I = 2
    lC = Range("XFD1").End(xlToLeft).Column
    LRow = Range("C" & Rows.Count).End(xlUp).Row
    Do
        LR = wf.Min(Range("A" & I).End(xlDown).Row, LRow)
        
        For J = I + 1 To LR - 1
            For K = 1 To lC
                Cells(I, K) = Cells(I, K) & Cells(J, K)
            Next K
        Next J
        
    I = LR
    Loop Until LR = Range("C" & Rows.Count).End(xlUp).Row
    
    'delete blank rows - Filter and delete would achieve same thing
    For L = LRow To 1 Step -1
        If Cells(L, "A") = "" Then
            Rows(L).EntireRow.Delete
        End If
    Next L
    
End Sub
 
Upvote 0
Thanks again, but I still get an error. Starter file has seven lines as shown in the previous post and the output file still seems to have an error.
[TABLE="width: 420"]
<COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6400" width=175><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" width=98><TBODY>[TR]
[TD="class: xl65, width: 36, bgcolor: transparent"]Item[/TD]
[TD="class: xl65, width: 61, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl65, width: 175, bgcolor: transparent"]Reference[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Part[/TD]
[TD="class: xl65, width: 79, bgcolor: transparent"]TOLERANCE[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]VOLTAGE[/TD]
[TD="class: xl65, width: 98, bgcolor: transparent"]INTERNAL P.N.[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]186[/TD]
[TD="class: xl65, bgcolor: transparent"]C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39,C40,C41,C42,C45,C46,C50,C51,C52,C56,C58,C59,C62,C63,C64,C68,C72,C73,C74,C78,C82,C83,C84,C88,C92,C93,C94,C98,C102,C103,C104,C108,C112,C113,C114,C118,C122,C123,C124,C128,C129,C130,C131,C133,C135,C138,C142,C143,C145,C149,C151,C154,C156,C158,C161,C162,C164,C166,C167,C169,C170,C171,C172,C173,C174,C175,C180,C197,C198,C203,C207,C208,C212,C213,C217,C218,C219,C220,C221,C222,C223,C226,C227,C229,C230,C232,C233,C255,C257,C258,C259,C262,C265,C266,C269,C270,C273,C274,C276,C279,C280,C281,C282,C283,C286,C287,C288,C290,C291,C292,C294,C295,C296,C298,C301,C302,C303,C304,C305,C307,C312,C314,C316,C317,C318,C319,C320,C321,C322,C323,C328,C345,C346,C351,C355,C356,C360,C361,C365,C366,C367,C368,C369,C370,C371,C374,C375,C377,C378,C380,C381,C403,C408,C409,C410,C412,C413,C418,C419,C425,C427,C428,C429,C430,C507,C508,C521, C525[/TD]
[TD="class: xl65, bgcolor: transparent"]0.10uF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.1[/TD]
[TD="class: xl65, bgcolor: transparent"]25V[/TD]
[TD="class: xl65, bgcolor: transparent"]MS30797[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl65, bgcolor: transparent"]C5,C9,C11,C16,C19,C23,C26,C30,C33,C35[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]500V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]5595926[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent"]C6,C10,C12,C445[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, bgcolor: transparent"]C17,C20,C24,C27,C31,C34,C36[/TD]
[TD="class: xl65, bgcolor: transparent"]150pF[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4713371[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]56[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]31[/TD]
[TD="class: xl65, bgcolor: transparent"]C43,C139,C144C44[/TD]
[TD="class: xl65, bgcolor: transparent"]22pF820pF[/TD]
[TD="class: xl65, bgcolor: transparent"]0.050.05[/TD]
[TD="class: xl65, bgcolor: transparent"]200V50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4.71143E+13[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"]C44[/TD]
[TD="class: xl65, bgcolor: transparent"]820pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"]50V[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3379299[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl65, bgcolor: transparent"]C47,C57,C69,C79,C89,C99,C109,C119,C267,C271,C272,[/TD]
[TD="class: xl65, bgcolor: transparent"]330pF[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0.05[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]7752603[/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
Whats the error?

this is the output I get after running the code


Excel 2010
ABCDEFG
1ItemQuantityReferencePartTOLERANCEVOLTAGEINTERNAL P.N.
21186C1,C2,C3,C4,C7,C8,C13,C14,C15,C18,C21,C22,C25,C28,C29,C32,C37,C38,C39,C40,C41,C42,C45,C46,C50,C51,C52,C56,C58,C59,C62,C63,C64,C68,C72,C73,C74,C78,C82,C83,C84,C88,C92,C93,C94,C98,C102,C103,C104,C108,C112,C113,C114,C118,C122,C123,C124,C128,C129,C130,C131,C133,C135,C138,C142,C143,C145,C149,C151,C154,C156,C158,C161,C162,C164,C166,C167,C169,C170,C171,C172,C173,C174,C175,C180,C197,C198,C203,C207,C208,C212,C213,C217,C218,C219,C220,C221,C222,C223,C226,C227,C229,C230,C232,C233,C255,C257,C258,C259,C262,C265,C266,C269,C270,C273,C274,C276,C279,C280,C281,C282,C283,C286,C287,C288,C290,C291,C292,C294,C295,C296,C298,C301,C302,C303,C304,C305,C307,C312,C314,C316,C317,C318,C319,C320,C321,C322,C323,C328,C345,C346,C351,C355,C356,C360,C361,C365,C366,C367,C368,C369,C370,C371,C374,C375,C377,C378,C380,C381,C403,C408,C409,C410,C412,C413,C418,C419,C425,C427,C428,C429,C430,C507,C508,C521, C5250.10uF0.125VMS30797
3210C5,C9,C11,C16,C19,C23,C26,C30,C33,C35150pF500V5595926
434C6,C10,C12,C445150pF0.0550V4713371
547C17,C20,C24,C27,C31,C34,C36150pF50V4713371
65631C43,C139,C144C4422pF820pF0.050.05200V50V4.71143E+13
761C44820pF0.0550V3379299
8713C47,C57,C69,C79,C89,C99,C109,C119,C267,C271,C272,330pF0.057752603
Sheet9
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
S
  • Solved
Tranpose with Editing
Replies
7
Views
1K
Rick Rothstein
Rick Rothstein
N
  • Question Question
How to Create Multiple Reports from One Sheet
Replies
1
Views
2K
Logit
Logit
N
  • Question Question
excel macro to split data into multiple worksheets based on conditions worksheet
Replies
4
Views
4K
Fluff
Fluff
M
  • Question Question
Index Match formula with multiple criteria
Replies
5
Views
777
DanteAmor
DanteAmor

Forum statistics

Threads
1,222,753
Messages
6,168,011
Members
452,160
Latest member
Bekerinik

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top