Forum Discussion

Eladnoam2's avatar
Eladnoam2
Copper Contributor
Oct 14, 2021
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 ...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 19, 2021

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.

Eladnoam2's avatar
Eladnoam2
Copper Contributor
Oct 21, 2021

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

 

Resources