Delete rows on duplicate text and add its values to the first

  • [ATTACH=JSON]{"data-align":"none","data-attachmentid":"1216670","data-size":"custom","height":"540","width":"534"}[/ATTACH]


    Hi everyone.


    What I would like here is to compare the texts in column B, if the below cell is the same then ad its value to the first one and delete the row.


    But for example B10 and B11 are not the same as B33:B35 so I would like to compare only the ones which come one after the other.


    See Image above with the first table as raw data and the second as treated data.


    Please help.


    Thank you

  • Hello,


    Unfortunately ... pictures are totally inert objects ... :-(


    Why don't you post your file ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 907"]

    [tr]


    [TD="align: right"]25-03-2019 07:24:30[/TD]

    [td]

    CIP_CIP_BIF00001_

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 08:55:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 09:57:30[/TD]

    [td]

    NBNG50999

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 12:31:30[/TD]

    [td]

    CIP_NBNG50999

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:28:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 21:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 22:13:30[/TD]

    [td]

    CIP_KON10050_

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 23:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:53:30[/TD]

    [td]

    QEN00047

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 09:38:30[/TD]

    [td]

    CIP_QEN00047_

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:47:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:50:30[/TD]

    [td]

    REN07005

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 15:52:30[/TD]

    [td]

    CIP_REN07005

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 16:51:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 17:14:30[/TD]

    [td]

    CIP_CIP_REN07005

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 18:17:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 19:04:30[/TD]

    [td]

    LQN00118

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 21:23:30[/TD]

    [td]

    CIP_LQN00118_

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 22:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]27-03-2019 06:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [/TABLE]


    This is how I managed to work my way through it with IF, AND and EXACT commands and then I have a macro where I select the rows with X and then copy them to a new sheet where I can construct a graph or chart with a treated data.


    Hope this will give you and idea what I would like a VBA code for.


    Thank you