Forum Discussion
textjoin
Hi. first of all sorry for my english I have a sheet with 365,000 rows. I need to concatenate the values in column D where the cells in columns A, B and C have the same values.
Interestingly, 64-bit Excel can handle the GROUPBY solution without issue for 360,000 rows at about .5 seconds. It's a bit faster without HSTACK (presuming columns are adjacent).
Really intresting, thank you for sharing