JMP 18 for Mac has a problem where empty cells get filled in with values from the adjacent column in the table that is being queried.
For example, if I do
SELECT 555, null
Then Column 1 and Column 2 both get populated with 555
This was reported in June of 2024 but I still don't have a solution from the development team at JMP 18. Is there any workaround that I can use so that I can trust my data in JMP?