Forum Discussion
Formula challenge: re-shape and cleanup
You're tasked with re-shaping and cleaning up the fictional Faber College alumni list to be used for a mail merge. Going from this: To this: To spice things up, the First and Last n...
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.