columns shift to the right when copying from excel to jmpwhen I copy a table in excel and the use ctlr + shift + V to copy with header the content of my tables shifts to the right, so the data doesn't match the column header.
have anyone else seen this issue and know what to do besides only opening with the excel wizard?
this is how it looks in jmp and below is the table in excel.
Re: columns shift to the right when copying from excel to jmpthanks for replying - a colleague of mine found the error and it have been solved.
apparantly there was a quotation hidden in the column from where the table got the projekt info, it was not visbile except when copying.
Re: columns shift to the right when copying from excel to jmpI believe it has to do with the quotation marks in the project column. Can you post the Excel file so I can experiment with it? Also, which version of JMP are you using? Thanks - Hyde
