I have a excel problem I can't figure out, forgive me if this is an easy one. I wasn't even sure what to search for to find existing threads on this type of issue.
I have data of something like 400 respondents, and each one filled out 9 separate forms, so each user has 9 rows. So right now column a has the user ID (repeated 9 times per participant), colum b has the label of what form they filled out and c-ak is the data. Separately I have each participants demographic info, column a being the matching user ID and then b-w being that data. I want to attach each users demographic data after their regular data, so it is repeated 9 times for each person.
Does that make sense? What command would I use to do that? I want a command that will look at column a, figure out the participants user ID, then go to the demographics and find that same user ID and retrieve the following columns b-w. Is this possible? Can anyone at least point me in the correct direction?
Thanks!
-- Mike
Bookmarks