Posts by dimv

    Hi,


    I have the columns below:
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 111"]A1[/TD]
    [TD="width: 111"]B1[/TD]
    [TD="width: 97"]C1[/TD]
    [TD="width: 128"]D1[/TD]
    [TD="width: 128"]E1[/TD]

    [/tr]


    [tr]


    [TD="class: xl65"]down_event_start[/TD]
    [TD="class: xl65"]down_event_end[/TD]
    [TD="class: xl65"]siteid[/TD]
    [TD="class: xl65"]hostname[/TD]
    [TD="class: xl65"]metric[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]18/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:40[/TD]
    [TD="class: xl64"]net-1[/TD]
    [TD="class: xl63"]net-1-ce.net[/TD]
    [TD="class: xl63"]main_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]19/12/2018 10:20[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:50[/TD]
    [TD="class: xl64"]net-1[/TD]
    [TD="class: xl63"]net-1-cpe.net[/TD]
    [TD="class: xl63"]backup_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]19/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:40[/TD]
    [TD="class: xl64"]net-2[/TD]
    [TD="class: xl63"]net-2-ce.net[/TD]
    [TD="class: xl63"]main_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]18/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:40[/TD]
    [TD="class: xl64"]net-3[/TD]
    [TD="class: xl63"]net-3-ce.net[/TD]
    [TD="class: xl63"]main_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]19/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:50[/TD]
    [TD="class: xl64"]net-3[/TD]
    [TD="class: xl63"]net-3-cpe.net[/TD]
    [TD="class: xl63"]backup_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]19/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]19/12/2018 10:40[/TD]
    [TD="class: xl64"]net-4[/TD]
    [TD="class: xl63"]net-4-ce.net[/TD]
    [TD="class: xl63"]main_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]20/12/2018 10:25[/TD]
    [TD="class: xl64, align: right"]20/12/2018 10:55[/TD]
    [TD="class: xl64"]net-1[/TD]
    [TD="class: xl63"]net-1-ce.net[/TD]
    [TD="class: xl63"]main_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]20/12/2018 10:00[/TD]
    [TD="class: xl64, align: right"]20/12/2018 10:40[/TD]
    [TD="class: xl64"]net-1[/TD]
    [TD="class: xl63"]net-1-cpe.net[/TD]
    [TD="class: xl63"]backup_availability[/TD]

    [/tr]


    [tr]


    [TD="class: xl64, align: right"]20/12/2018 11:00[/TD]
    [TD="class: xl64, align: right"]20/12/2018 11:40[/TD]
    [TD="class: xl64"]net-1[/TD]
    [TD="class: xl63"]net-1-cpe.net[/TD]
    [TD="class: xl63"]backup_availability[/TD]

    [/tr]


    [/TABLE]


    I am trying to estimate the duratuion of events for a siteid (column D) when the metic (column E) takes the values (main_availability and backup_availability) in common time periods.


    For example, in the above data table, the requested result would be
    a) net-1, duration=20 min -> rows 1,2
    b) net-3, duration=40 min -> rows 4,5
    c) net-1, duration=15 min -> 7,8


    for a), main_availability "down event start" starts at 18/12/2018 10:00 and before its ending, the backup_availability "down_event_ start" begins. From that moment the common downtime event begins for siteid net-1 and it lasts until the first "down_event_up" comes.
    So, the common duration will be: 19/12/2018 10:40 (main_availability down_event_start) - 19/12/2018 10:20 (backup_availability down_event_end)


    i don't know how to apply that logic with vba.


    Thanks

    Hello,


    I am trying to insert multiple excel ranges to multiple ppt slides with the data below:
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 86"]Title[/TD]
    [TD="width: 70"]Status[/TD]
    [TD="width: 98"]Issues[/TD]
    [TD="width: 64"]slide 1[/TD]

    [/tr]


    [tr]


    [td]

    a1

    [/td]


    [td]

    ok

    [/td]


    [td]

    xxxxx

    [/td]


    [/tr]


    [tr]


    [td]

    a2

    [/td]


    [td]

    ok

    [/td]


    [td]

    xxxxx

    [/td]


    [/tr]


    [tr]


    [td]

    Title

    [/td]


    [td]

    Status

    [/td]


    [td]

    Issues

    [/td]


    [td]

    slide 2

    [/td]


    [/tr]


    [tr]


    [td]

    a3

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    a4

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    a5

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    a6

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    Title

    [/td]


    [td]

    Status

    [/td]


    [td]

    Issues

    [/td]


    [td]

    slide 3

    [/td]


    [/tr]


    [tr]


    [td]

    a7

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    a8

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [tr]


    [td]

    a9

    [/td]


    [td]

    ok

    [/td]


    [td]

    ddddd

    [/td]


    [/tr]


    [/TABLE]

    i want to insert to each slide the range from the title-row until the begging of the next one (i.e A1:C3, A4:C8, A9:C12).


    If the number of rows were constant between the titles i.e 2 rows, then i could manage it with the below code (part of the code):


    [VBA]MySlideArray = Array(52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62)
    MyRangeArray = Array(Sheets("output2").Range("A1:C3"), Sheets("output2").Range("A4:C7"),....)
    For x2 = LBound(MySlideArray) To UBound(MySlideArray)
    MyRangeArray(x2).Copy
    Set shp = DPPt.Slides(MySlideArray(x2)).Shapes.PasteSpecial(DataType:=10, DisplayAsIcon:=msoFalse, link:=msoFalse)
    Next x2
    [/VBA]


    With the above data, i can't set fixed ranges inside the Array.


    Any help???


    Thanks

    Hi,


    i have the below script that transposes a range but the new rows (= transposed column cells) inherit the format of A1 something that i don't want. I want each transposed cell to keep its own format (i.e. color, bold etc)


    [VBA]Sub Sheet3_Button1_Click()
    Dim n As Long, c As Long, u(), e
    With Range("A1").CurrentRegion
    n = .Cells.Count
    ReDim u(1 To n, 1 To 1)
    For Each e In .Cells
    c = c + 1
    u(c, 1) = e.Value
    Next e
    .ClearContents
    End With
    Range("A1").Resize(n) = u
    End Sub[/VBA]

    Let me describe the issue


    I have a range of columns A1-Cxx. The input of each column is text inserted from another worksheet. The length of each text is not constant


    For example, i have the below table. I want to insert the range to multiple ppt slides and i want for each slide, the inserted sub ranges to have at the top the titles of row 1. If the rows A2-Axx had constant height, then i know how to enter every i.e 4 rows a new row with the titles1,2,3 based in the fact that each slide takes a range of 5 rows in order that range to be fitted to each slide


    As you can observe, because the row height i.e row2, is greater than that of row 4, i need a rule that will insert a new row and the outcome will fit to a ppt slide. So, one solution that cross my mind is to set a rows' height max value accumulatively.
    Another solution could be a predefined constant height for every row but in that case, the wrapped text inserted in the cell couldn't be visible if its length was too big
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"] [/TD]
    [TD="class: xl65, width: 180"]Title 1[/TD]
    [TD="class: xl65, width: 106"]Title 2[/TD]
    [TD="class: xl65, width: 286"]Title 3[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]1[/TD]
    [TD="class: xl66, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl67"]xxxxxxxxxxxx[/TD]
    [TD="class: xl66, width: 286"]xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]2[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]xxxx [/TD]
    [TD="class: xl70, width: 286"]xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]3[/TD]
    [TD="class: xl68"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl68"]ttttttt[/TD]
    [TD="class: xl68"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]4[/TD]
    [TD="class: xl68"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl68"]ttttttt[/TD]
    [TD="class: xl68"]tttttttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]5[/TD]
    [TD="class: xl66, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl69"]tttttttttttttttttt[/TD]
    [TD="class: xl69"]tttttttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]6[/TD]
    [TD="class: xl69"]xxxx [/TD]
    [TD="class: xl69"]xxxx [/TD]
    [TD="class: xl69"]xxxx [/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]7[/TD]
    [TD="class: xl66, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl69"]xx[/TD]
    [TD="class: xl69"]xxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]8[/TD]
    [TD="class: xl68"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl68"]ttttttt[/TD]
    [TD="class: xl68"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]9[/TD]
    [TD="class: xl68"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl68"]ttttttt[/TD]
    [TD="class: xl68"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl64"]10[/TD]
    [TD="class: xl68"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl68"]ttttttt[/TD]
    [TD="class: xl68"]tttttttttttttt[/TD]

    [/tr]


    [/TABLE]


    so, in the above table, if the rule of max height for rows a1+a2+...+an = b, then the script's output could be sth like that, where height[a1+a2]=height[a3+a4+a5+a6]=height [a7+a8+a9+a10]<=b
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 478"]

    [tr]


    [TD="width: 64"] [/TD]
    [TD="class: xl66, width: 180"]Title 1[/TD]
    [TD="class: xl66, width: 106"]Title 2[/TD]
    [TD="class: xl66, width: 286"]Title 3[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a1[/TD]
    [TD="class: xl67, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl68"]xxxxxxxxxxxx[/TD]
    [TD="class: xl67, width: 286"]xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a2[/TD]
    [TD="class: xl70"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl70"]xxxx [/TD]
    [TD="class: xl71, width: 286"]xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"] [/TD]
    [TD="class: xl66"]Title 1[/TD]
    [TD="class: xl66"]Title 2[/TD]
    [TD="class: xl66"]Title 3[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a3[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]ttttttt[/TD]
    [TD="class: xl69"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a4[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]ttttttt[/TD]
    [TD="class: xl69"]tttttttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a5[/TD]
    [TD="class: xl67, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl70"]tttttttttttttttttt[/TD]
    [TD="class: xl70"]tttttttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a6[/TD]
    [TD="class: xl70"]xxxx [/TD]
    [TD="class: xl70"]xxxx [/TD]
    [TD="class: xl70"]xxxx [/TD]

    [/tr]


    [tr]


    [TD="class: xl72"] [/TD]
    [TD="class: xl66"]Title 1[/TD]
    [TD="class: xl66"]Title 2[/TD]
    [TD="class: xl66"]Title 3[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a7[/TD]
    [TD="class: xl67, width: 180"]xxxxxxxx
    xxxxxxxxxxxxxxxxx
    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz[/TD]
    [TD="class: xl70"]xx[/TD]
    [TD="class: xl70"]xxxxxxx[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a8[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]ttttttt[/TD]
    [TD="class: xl69"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a9[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]ttttttt[/TD]
    [TD="class: xl69"]tttttttttttttt[/TD]

    [/tr]


    [tr]


    [TD="class: xl72"]a10[/TD]
    [TD="class: xl69"]xxxxxxxxxxxxxxxxxxxxxxx[/TD]
    [TD="class: xl69"]ttttttt[/TD]
    [TD="class: xl69"]tttttttttttttt[/TD]

    [/tr]


    [/TABLE]

    Hi,
    I have a range i.e. A1:C10, where A1:C1 is the columns' titles.
    I want to insert blank rows between that range but as the rows height varries, i need to set a max (sum) rows height as a rule for the blank row insertion i.e. every in-between total rows height<200, insert row.


    Any help?


    Thanks in advance

    Hi,


    I have four columns (A-D), and in column C i have inserted with a function pictures/shapes.


    I tried, according to Column A, to delete entire rows if the related cells of column A are blank/empty. The row is deleted but the shape is not removed
    In my example below, the rows 3,4 must be deleted but i dont know how


    Any ideas?
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"] [/TD]
    [TD="width: 221"]column A[/TD]
    [TD="width: 75"]column B[/TD]
    [TD="width: 115"]column C[/TD]
    [TD="width: 115"]column D[/TD]

    [/tr]


    [tr]


    [td]

    row1

    [/td]


    [td]

    test1

    [/td]


    [td]

    21/09/2018

    [/td]


    [TD="width: 115"]picture1[/TD]

    [td]

    B2B/MPLS & VoIP

    [/td]


    [/tr]


    [tr]


    [td]

    row2

    [/td]


    [td]

    test2

    [/td]


    [td]

    28/09/2018

    [/td]


    [TD="width: 115"]picture2
    [/TD]

    [td]

    B2B/VPN

    [/td]


    [/tr]


    [tr]


    [td]

    row3

    [/td]


    [td][/td]


    [td][/td]


    [TD="width: 115"]picture3
    [/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    row4

    [/td]


    [td][/td]


    [td][/td]


    [TD="width: 115"]picture4
    [/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    row5

    [/td]


    [td]

    test3

    [/td]


    [td]

    28/09/2018

    [/td]


    [TD="align: left"]picture5[/TD]

    [td]

    B2B/VPN

    [/td]


    [/tr]


    [/TABLE]

    Hi


    I want to create a generic script that relates the range of the rows to the number of slides. For example, if i have 20 rows and i want to insert 5rows/slide, i will need 4 slides.
    As the number of rows is updated, the next time the number can be increased so the slides must be more than the previous time.
    I know how to manually relate rows to slides but i want, if it is possible, to do it automatically without having every time to count the total number of rows.


    Any help?


    Thanks

    Hi,
    I have the below range from A-D, where the first row depicts the title of each column.
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 86"]Title[/TD]
    [TD="width: 75"]Deadline[/TD]
    [TD="width: 75"]Status[/TD]
    [TD="width: 125"]Segment/Category[/TD]

    [/tr]


    [tr]


    [td]

    x1_1

    [/td]


    [TD="align: right"]1/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    ict

    [/td]


    [/tr]


    [tr]


    [td]

    x1_2

    [/td]


    [TD="align: right"]2/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    ipvpn

    [/td]


    [/tr]


    [tr]


    [td]

    x1_3

    [/td]


    [TD="align: right"]3/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    b2b

    [/td]


    [/tr]


    [tr]


    [td]

    x1_4

    [/td]


    [TD="align: right"]4/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    ict

    [/td]


    [/tr]


    [tr]


    [td]

    x1_5

    [/td]


    [TD="align: right"]5/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    ipvpn

    [/td]


    [/tr]


    [tr]


    [td]

    x1_6

    [/td]


    [TD="align: right"]6/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    b2b

    [/td]


    [/tr]


    [/TABLE]

    I want to insert to ppt, in two slides, the above table, for example x1_1-x1_3 ->slide 1, x1_4-x1_6 -> slide 2 but in each new sub table i want to keep the titles (=row1)


    I have isolated below, a vba piece of my code that haddles the insertion of each sub range


    [VBA] MySlideArray = Array(1, 2)
    MyRangeArray = Array(Sheet6.Range("A1:D4"), Sheet6.Range("A1:D1", "A5:D7"))
    For x = LBound(MySlideArray) To UBound(MySlideArray)
    MyRangeArray(x).Copy[/VBA]


    The part = Sheet6.Range("A1:D1", "A5:D7")), brings all the table instead of the union of row1+rows4,5,6
    I used the Union function but i had the same result


    Any ideas???


    The desirable result is:
    Slide 1 [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 86"]Title[/TD]
    [TD="width: 75"]Deadline[/TD]
    [TD="width: 75"]Status[/TD]
    [TD="width: 125"]Segment/Category[/TD]

    [/tr]


    [tr]


    [td]

    x1_1

    [/td]


    [TD="align: right"]1/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    ict

    [/td]


    [/tr]


    [tr]


    [td]

    x1_2

    [/td]


    [TD="align: right"]2/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    ipvpn

    [/td]


    [/tr]


    [tr]


    [td]

    x1_3

    [/td]


    [TD="align: right"]3/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    b2b

    [/td]


    [/tr]


    [/TABLE]

    Slide 2 [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 86"]Title[/TD]
    [TD="width: 75"]Deadline[/TD]
    [TD="width: 75"]Status[/TD]
    [TD="width: 125"]Segment/Category[/TD]

    [/tr]


    [tr]


    [td]

    x1_4

    [/td]


    [TD="align: right"]4/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    ict

    [/td]


    [/tr]


    [tr]


    [td]

    x1_5

    [/td]


    [TD="align: right"]5/1/2018[/TD]

    [td]

    closed

    [/td]


    [td]

    ipvpn

    [/td]


    [/tr]


    [tr]


    [td]

    x1_6

    [/td]


    [TD="align: right"]6/1/2018[/TD]

    [td]

    open

    [/td]


    [td]

    b2b

    [/td]


    [/tr]


    [/TABLE]

    Thanks

    Hi,
    I'm trying to transpose row cells data form one sheet to another with the below relust:
    Sheet 1 (not transposed data) [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]A[/TD]
    [TD="width: 64"]B[/TD]
    [TD="width: 64"]C[/TD]
    [TD="width: 64"]D[/TD]
    [TD="width: 64"]E[/TD]
    [TD="width: 64"]F[/TD]
    [TD="width: 64"]G[/TD]

    [/tr]


    [tr]


    [td]

    Name

    [/td]


    [td]

    Status

    [/td]


    [td]

    test1

    [/td]


    [td]

    test2

    [/td]


    [td]

    test3

    [/td]


    [td]

    test4

    [/td]


    [td]

    test5

    [/td]


    [/tr]


    [tr]


    [td]

    D1

    [/td]


    [td]

    Y

    [/td]


    [td]

    OK

    [/td]


    [td]

    Pending

    [/td]


    [td]

    Pending

    [/td]


    [td]

    Pending

    [/td]


    [td]

    Pending

    [/td]


    [/tr]


    [tr]


    [td]

    D2

    [/td]


    [td]

    Y

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    D3

    [/td]


    [td]

    N

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    D4

    [/td]


    [td]

    N

    [/td]


    [td]

    Pending

    [/td]


    [td]

    Pending

    [/td]


    [td]

    Pending

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    D5

    [/td]


    [td]

    Y

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td]

    OK

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]

    Sheet 2 (VBA output)


    If the value of column B equals to "Y", then bring the Name and the values of columns C-G. For each row, between the transposed data, there will be some rows space i.e. 3 rows, as shown below


    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]A[/TD]
    [TD="width: 64"]B[/TD]
    [TD="width: 64"]C[/TD]

    [/tr]


    [tr]


    [td]

    Name

    [/td]


    [td][/td]


    [td]

    Tests

    [/td]


    [/tr]


    [tr]


    [td]

    D1

    [/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    Pending

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    Pending

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    Pending

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    Pending

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Name

    [/td]


    [td][/td]


    [td]

    Tests

    [/td]


    [/tr]


    [tr]


    [td]

    D2

    [/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Name

    [/td]


    [td][/td]


    [td]

    Tests

    [/td]


    [/tr]


    [tr]


    [td]

    D5

    [/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td]

    OK

    [/td]


    [/tr]


    [/TABLE]


    Thanks in advance