How to remove empty rows when importing excel in JMP
Hi All,
I am importing an excel file to JMP. There are many empty rows in excel (I can not delete them manually as there are 10s of such excel files) and when I import them to JMP, I do not find any option to delete/remove/suppress these empty files. JMP do show option to suppress empty columns but nothing for empty rows (at least I couldn't find it). I tried to put "Suppress Empty Rows( 1 )" in t...