Forum Discussion
Formula challenge: re-shape and cleanup
Doing some more testing with this data set. I expanded the alumni list to just shy of 1 million rows. My solution and PeterBartholomew1 's formula produced #NUM! errors. I found HSTACK, when run by itself and stacking FirstWord and FinalWord, was failing with precisely 524,289 rows in the alumni named range. I shortened the range and HSTACK worked again.
The main formulas still produced #NUM! errors because WRAPROWS, CHOOSECOLS, CHOOSEROWS, TOCOL, etc. - had reached limits and were producing #NUM! errors, too. Granted, these functions are still in BETA but it's fascinating to get an idea of what they can handle. Maybe these limits will change once released.
For HSTACK it depends on both dimensions - number of stacked columns and number of rows in each. My short test gives
