Forum Discussion
merging cells
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?
hi HansVogelaar
i have many rows (950,000 rows). and when i put thw formula that u made, the Excel course from the load.
many of my cells (for example, the Animal, and not the Number) are empty. there for i want that the formula get action only in non-empty cells.
i tried somthing in the file below (red font), but its worng. (i thought to use in if statment...)
ty so much!
- u r genius. TY!! Hans Vogelaar