I have data from different excel files. They have an ID which shows where they come from. Can I connect them in to one file in order to "read" them in a correlation form?
This is exactly what I am doing now, but my data originates from 3 different models with distinct values, so essentially I had to create a superExcel with a primary structure based on my principal model, and adding indicators from other models as subcategories. My data is qualitative so there are no numeric values that need to be calculated by a formula. I think it should work somehow differently with numeric values corresponding to the same categories of data.