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!!
