Forum Discussion
Solved
merging cells
i have a long table like this: phone animal food 123 dog 123 cat 123 fish 123 pizza 123 123 hot dog 456 456 cat 789 fish pizza ...
See the attached workbook.
See the attached workbook.
hi,
i dont want to get a duplicate value, fo example:
i have a long table like this:
| phone | animal | food |
| 123 | dog | |
| 123 | dog | |
| 123 | fish | |
| 123 | pizza | |
| 123 | hot dog | |
| 123 | pizza |
and i want a result like this:
| phone | animal | food |
| 123 | dog,fish | pizza,hot dog |
and not like this:
| phone | animal | food |
| 123 | dog,dog,fish | pizza,hot dog,pizza |
ty so much!!
New version attached.
HansVogelaar ty!
hope that its the last one...
i have a table of 950,000 rows.
i want that the function play only on non empty cell. I thought...
=IF($A$2:$A$11<>"",TEXTJOIN(",",TRUE,UNIQUE(IF($C$2:$C$11=$F2,$A$2:$A$11&"",""))),"")
but its not work...
any idea? TY!!
The formula in the attachment to my previous reply already skips empty cells. What exactly is the problem?
- u r genius. TY!! Hans Vogelaar