Hoping for help!
I have a spreadsheet with multiple case records (let's say A-Z) that each have a value - say 5 with the value A, 10 with the value B, etc . . .and I separately have an index of value A to value Z that has values corresponding to each. There are too many values to create an if statement. Is there a way to merge spreadsheets so each case record A, for example, gets the value assigned to it from my "index table" and so on. . . As you can see, this is NOT a one-to-one merge, since there are multiple cases with each value (A-Z) and one table with individual "index" rows (A-Z).
I am going to ultimately put these into STATA, maybe it is easier to do it there? But I would rather do it in excel so I have the spreadsheet with all my merged values.
Thank you very much, this is for my dissertation, I have 360,000 rows of data and multiple covariates I need to merge into these case records. . .ugh
Frankie
Bookmarks