Efficiency when iterating

[Paul_Danyliuk]

P.S. @Robert_Clay, Just posted the trick with how to quickly compose a formula to copy all columns:

Instantly make a button to copy a row with lots of columns

Not a hack per se, just a smart way to speed up formula creation to copy a row (e.g. from the main table to a log table), using some regex. Here’s a video how you can make such log table in 2 minutes: Copy the table to a text editor or right into an offline / online editor that supports regular expressions (I prefer regex101.com, not affiliated). Remove everything but the headers Set up replacement with regular expressions: Search: ([^\t]+)\t? (means capture each element between tabs) …