Using Excel Wizard to Import Column Headings of Merged Cells
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 " R...