Merge cells yet keep data with UNIQUE + JOIN So, this can work for small datasets, but what to do when they get bigger? It requires for you to know the exact positions of duplicates, and it's you who should point them out to the formula. Once the rows are merged, you can get rid of formulas and keep only the text by the example of this tutorial: Convert formulas to values in Google SheetsĪs simple as this way may seem, it is obviously far from ideal. Or use spaces with any other marks to combine duplicate rows together:. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |