Dealing with RedCap Dataset

[Anonymous]

Hi All

I'm dealing with a dataset from REDCap survey that allows for more than one response to a question. My dataset currently looks like the screenshot below. I'm not sure how to create useful visualisations using it. It would help to have one field (ie risk factors) with all the responses in one column. Any help is much appreciated. Thanks 🙂

[Anonymous]

Thanks 🙂

Yes, that's what I've done. 

[amitchandak · Accepted solution]

@Anonymous , Very first observation, you need unpivot the data

https://radacad.com/pivot-and-unpivot-with-power-bi