[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