Problem: to remove the duplicate values and to assign the corresponding values. Some of the files have more than a 10,000 rows (some of which are duplicates), so not appropriate, rather impossible to do it manually. Is there any formula to use to remove duplicates, combine the corresponding values using separator and compile a table with no duplicates (file attached)?
For example, for the number 273.185 (in column A) I have 5 corresponding numbers in each of the columns B, C and D. I would like to delete the duplicates in the Column A but to add the corresponding numbers in Columns B, C and D.
It should look something like:
Column A | Column B | Column C | Column D
273.185 | 722286, 699119, 148561, 518520, 289730 | 1344, 4592, 6342, 6702, 9321 | 89, 71, 36, 54, 97
Any suggestions?
Bookmarks