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.
Riny_van_Eekelen, yes, thats what I meant, even worse, the Excel close down because of the load.
I attached file, my file is much bigger, i have 7 columns, with much more data.
in the file, i put the formula of @Hans Vogelaar
only at the first 100 rows, and its take a minute to end the action.
thank you so much!
soory about my bad English
If slightly modify HansVogelaar formula
=IFERROR( TEXTJOIN(",",1, FILTER(Table1[animal], NOT(ISBLANK(Table1[animal])) * (Table1[phone] = F2) ) ), "")perhaps it'll be bit faster
sorry, but still the Excel close down because of the load...
Help!! PLZ