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 |
| 789 | hot dog |
and i want a result like this:
| phone | animal | food |
| 123 | dog,cat,fish | pizza,hot dog |
| 456 | cat | |
| 789 | fish | pizza,hot dog |
ty!!
See the attached workbook.
13 Replies
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.
