Collapsing rows for organizing data correctly (survey data)

[Tor Haug Anonsen]

Hello gang

I'm working on cleaning/organizing a very big dataset of survey data. The goal is to see what factors affect attention to ads. I've attached a picture that explains my problem.

I've only shown the response from one respondent (ID:1), but there are of course several thousand respondents which responses/data points that also needs to be organized/collapsed

So the question is how do i get it from how its organized now ("Wrong") to how I would want it to be organized ("Correct"). I assume i need to use some kind of collapse command, but unsure of what the exact code needs to be.



Any help would be hugely appreciated.

Kind regards

Tor

[Maarten Buis]

collapse (mean) Q1-Q10, by(ID)

[Tor Haug Anonsen]

collapse (mean) Q1-Q10, by(ID)

I think that fixed it! - thank you so much!