topic How do I copy columns with formulas from one data table into another data table, while preserving the formulas? in Discussions

How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

hokiewoody95 — Tue, 18 Nov 2025 14:33:20 GMT

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

hogi — Tue, 18 Nov 2025 14:44:10 GMT

via Copy columns / paste columns:

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

hokiewoody95 — Tue, 18 Nov 2025 15:17:37 GMT

Hi Hogi, thanks for the response. That appears to work. I was using the cut/paste options in the Edit menu, but it appears right clicking on the column gives additional, and different, cut/paste options. Thanks!

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

hogi — Tue, 18 Nov 2025 19:52:22 GMT

No worries, we all started somewhere.

There are multiple ways to copy columns, and there may be documentation detailing which function should be used for each approach:

with and without the name/header
with and without data
with and without properties, like the formula.

Copy/Paste columns from the header menu is my favorite one - it copies the column with the name, with the properties, and when you press CTRL+A before you copy the column: even with the data (caution: copy is fast, paste can be very slow!).
It's such a helpful function, but it wasn't there from the beginning:

... and it got better and better over the time.
The latest improvement: JMP19 checks if the script on the clipboard is actually a column script; otherwise, it returns an error message.

More tricks like this? Just have a look at .
You don't need to know about all the Easter eggs listed there – simply ignore the ones you don't need.
Pick your favorite ones and enjoy the efficiency boost for JMP!