Hi: I have an excel workbook that takes a set of data which has three columns (user ID, Question ID, and Answer). I need to translate that dataset into a table so that I can perform some calculations and averaging on the answers. I have attached a file that shows what my raw data looks like and what I want the resulting table to look like. This dataset only contains 10 users and their responses and it works fine for small datasets but I have a dataset with 6000 sets of responses that I want to do the same analysis on and it it is VERY slow. I am currently using INDEX MATCH functions to rearrange the data. I was previously using SUMPRODUCT, which worked but from what I read is slower than INDEX MATCH. Does anyone know of yet a faster way to do this? I know this type of stuff should really be done in a database, but I don't know databases very well. My goal is to be able to process the data in less than 1 hour; right now with 6000 users, it takes more than a day. Any help is appreciated. I do know how to write macros but can't figure out quite how to write a macro to do this quickly.
Bookmarks