Hello guys,
im setting up a tool and one of the steps is to merge some data together.
It's a large document and my initial idea was to cycle back from last row, and check 2 cells, if they match between the 2 rows, a 3rd cell merges both row values and deletes the old one.
<tbody>
</tbody>result:3000 /random/ match/ 3
This is too slow and I'm not sure how to approach it, the data size will only increase through out time.
Going row by row seems to be inefficient, but I can't think of a better way
im setting up a tool and one of the steps is to merge some data together.
It's a large document and my initial idea was to cycle back from last row, and check 2 cells, if they match between the 2 rows, a 3rd cell merges both row values and deletes the old one.
row nr / | 1st value/ | 2nd value/ | merge value |
3000 | /random | /match/ | 1 |
3001 | /random | /match/ | 2 |
<tbody>
</tbody>
This is too slow and I'm not sure how to approach it, the data size will only increase through out time.
Going row by row seems to be inefficient, but I can't think of a better way
Last edited: