Forum Discussion
merging cells
See the attached workbook.
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!
Eladnoam2 You wrote ".....when I put the formula that u made, the Excel course from the load." Did you perhaps mean to say that the formula based solution offered by HansVogelaar , applied to 950 thousand rows caused Excel to become very slow or that it is no longer responding?
If so, perhaps you want to consider a Power Query solution (see attached). PQ deals with large data sets very well. Though, I suspect that your real data set is not about three columns of telephone numbers, foods and animals. So, you can't just apply the query in the attached file to anything not looking exactly the same as your sample data. Perhaps best that you show us what you are really dealing with. Then we don't need to guess what your true intentions are.
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
I'm sorry, I really don't understand what's wrong with the solution that I proposed. It does not have the problem that your formula has.
