So I have 4 datasets and I want to merge the summary together so they form a "time-series" so to speak
I want to collect all the details (e.g., A great deal = 4; A little = 3, and so on and so forth and output it into an excel file for every question I have in the dataset and then merge them and separate by column, so the end result would look like 2015; A great deal = 4, etc.
The challenge is that we can't really merge them 1 to 1 because the number of observation is not the same for each datasets. Also, each question has different choices, like for question 1, those are the choices but question 2 has different choices.
Can you provide some sample/dummy data please ?