Forum Discussion
Eladnoam2
Oct 14, 2021Copper Contributor
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 ...
- Oct 14, 2021
See the attached workbook.
SergeiBaklan
Oct 23, 2021Diamond Contributor
If slightly modify HansVogelaar formula
=IFERROR( TEXTJOIN(",",1, FILTER(Table1[animal], NOT(ISBLANK(Table1[animal])) * (Table1[phone] = F2) ) ), "")
perhaps it'll be bit faster
Eladnoam2
Oct 23, 2021Copper Contributor
sorry, but still the Excel close down because of the load...
Help!! PLZ