Stack side by side tables from excel and add header columns
I have been struggling for 2 days pulling data from excel into JMP in the correct format. I have hundreds of excel sheets, but the data is disorganised. There are many tables next to eachother (hundreds) in an excel sheet.I want to stack the data across the different tables, but also make new columns with the associated header data. I have only been able to achieve this on one table, but can't rep...