Greetings everyone, I had a problem in merging duplicate cells while retaining the values in separate rows.
I have duplicates in single column while another column have different values, and I would like to merge the duplicate cells in column A, while still retaining all the values in column B's cells.
I have come across a few of other codes, and here is the closest one I am able to search:
Please Login or Register to view this content.
The first code was to clear the duplicates, the second code is able to merge the blank-cells between the cells that contain value(text), however it also merged some of the cells that have data (in between the blank-cells).
(The third code did not work for me though, it cleared most of the data.)
I have only limited programming knowledge, and I have tried to modify the code I have found above, but to no avail.
It would be much appreciated if anyone could provide me with a solution that could achieve this. Thanks in advance.