topic Re: Using Excel Wizard to Import Column Headings of Merged Cells in Discussions

Using Excel Wizard to Import Column Headings of Merged Cells

Mcc99 — Mon, 02 Sep 2024 19:05:38 GMT

I have a spreadsheet with multiple analytes formatted as the example below. The analyte identification is two merged cells, and below is the well # and the final concentration. When importing I need the column names to be "Analyte - Well" and "Analyte - Final", but it's just showing as "Analyte - Well" and "Final". How do I get the merged heading to show on the second column as well? I thought " Replicate Headers in Spanned Rows" in the Excel wizard under advanced settings would do so but it's not working , even when I identify two rows of headers.

Re: Using Excel Wizard to Import Column Headings of Merged Cells

txnelson — Mon, 02 Sep 2024 19:10:32 GMT

What version of JMP are you using?

Re: Using Excel Wizard to Import Column Headings of Merged Cells

Mcc99 — Mon, 02 Sep 2024 19:14:25 GMT

JMP Pro 16 on Windows.

Re: Using Excel Wizard to Import Column Headings of Merged Cells

txnelson — Mon, 02 Sep 2024 19:29:44 GMT

Using JMP 16.2 on Windows 11 I created a spreadsheet

With the A1 value (Header) merged and centered across A1-B1.

Using the Excel Wizard, I simply specified the Column Headers starting in row 1 and the Number of rows with column headers as 2 and finally the Data Starts on row 3

Clicking on the Import button I got

I have attached the Excel file. Try using it and see if you get what I got.

Re: Using Excel Wizard to Import Column Headings of Merged Cells

Mcc99 — Mon, 02 Sep 2024 19:52:48 GMT

Weird. With the example spreadsheet, the columns are correct, with the exact same settings I was using before. I went back to my spreadsheet and unmerged and then merged the columns headings again. And it worked on that version of the file. There must be an issue with how the instrument formats the software which was causing issues.

Re: Using Excel Wizard to Import Column Headings of Merged Cells

txnelson — Mon, 02 Sep 2024 19:55:46 GMT

Super......glad the problems was solved.