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...
This is my solution in 2026 using functions from my library BigSpill:
=LET(
remapped, BlockMapλ(Pinchλ(Alumni), 3, 1),
filtered, Excludeλ(remapped, "Bellman"),
names, Splitλ(TAKE(filtered, , 1), " "),
new, HSTACK(names, DROP(filtered, , 1)),
new
)