Hi,
I really hope someone can help me, because I've spent the last 4 hours trying to solve this my self.
I've made a survey regarding streaming and SoMe behaviour in Google Forms. One of the questions were "Which social media do you use?". Here I used the checkbox function In Google Forms with the possible answers Facebook, Instagram, Youtube, Snapchat etc. Now my Pivot table registers the ones who answered "Facebook" as on option, the ones who answered both Facebook and Instagram as another option, and the once who answered Facebook, Instagram and Snapchat as a third option. I want to separate each option so I can easily tell how many people answered "Facebook" and then compare it to their gender and ***.
"Which social media do you use" is "Hvilke sociale medier bruger du? (Vælg gerne flere)" in the Excel sheet. I would like to compare it with the gender and the age. In the sheet it's the questions "Hvilket køn er du?" and "Hvor gammel er du?".
Thank you!
Bookmarks