Add CopyRows() capability

[Paul_Danyliuk]

Meanwhile here’s a trick to make writing an AddRow() formula easier when tables are very wide:

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) …