Add a "Transpose" option to file imports

[jevanove]

What inspired this wish list request? 

I am currently using JMP 19.01. At my organization, we have many live excel spreadsheets which are used as "trackers" to record basic information about production records. However, many of them have each entry as a unique column, with the headers being in the rows of the second column. To make the data useful in JMP, I first need to transpose the tables.

What is the improvement you would like to see? 

I want there to be a checkbox in the Excel import wizard to transpose the file. Ideally, the transpose would be done after JMP has unmerged any cells, but before any assumptions have been made about data types. After selecting this box, JMP would show the preview of the transposed table, and then the standard options for things such as which row contains column headers, which row first contains data, etc. would be applied to the transposed table.

Add a "Transpose Table" checkbox during the file import.

Why is this idea important? 

Without this feature, I currently need to first import the worksheets and transpose each of them individually. However, because JMP will automatically detect column types, some columns will be detected as numeric, and others as character. This makes is so the transpose will fail, because the data types do not match. So, before a transpose can be completed, all the columns have to be standardized to the same data type, then the transpose can be completed. Doing this for each worksheet is a very painful process. Having a simple transpose checkbox in the import would save a significant amount of time, and would generally be a helpful feature for importing any tables that are not in the appropriate column-based format that JMP is coded to work with.

[hogi]

maybe best at the moment:
import all tables as Strings to separate table - transpose the JMP tables  - use MoveUp to assign the column names and adjust the data formats - combine the tables via concatenate.