Hello,
I need a macro to remove duplicates by row and also remove the blanks. Its a huge data by rows and columns
below example - duplicates "Rob & "goal" to be removed, but should retain unique and remove the blanks
<tbody>
</tbody>
Output -
<tbody>
</tbody>
I need a macro to remove duplicates by row and also remove the blanks. Its a huge data by rows and columns
below example - duplicates "Rob & "goal" to be removed, but should retain unique and remove the blanks
gulf | Rob | stat | Rob | aim | hero | fun | goal | view | review | page | goal |
<tbody>
</tbody>
Output -
gulf | Rob | stat | aim | hero | fun | goal | view | review | page |
<tbody>
</tbody>