Forum

Melissa Watson
@lissa
Active Member
Joined: Nov 13, 2021
Topics: 1 / Replies: 8
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hi Mynda, I appreciate that you have courses available that teach the various aspects of Excel. I am not a heavy user of Excel as I'm sure you are ...

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Also, I'm trying to group the Age and getting an error message "cannot group that selection." Why might that be (this is so frustrating)?

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hi Mynda, As a reminder, I don't have a vast knowledge of Excel so what's obvious to you might be unclear to me. Here's what I'm trying to under...

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hi Mynda, Your Response "I doubt you can collate your data in a tabular layout from the get go, as it probably comes from a survey system that p...

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

How? Is it not tabular? How else would you lay out yes and no responses that's easier to work with aligning with your tutorial?

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hi Mynda, No, the data does not come from a survey system that puts it in this format. I created the format and I enter the survey results manually...

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hi Mynda, I'm a bit unclear with this response regarding adding additional survey data. "...you need to load the data direct to the PivotTable,...

3 years ago
Reply
RE: How to Structure Pivot Table when Data has 1s and 0s from Survey Questions

Hello Mynda, Thanks for your response and for making me aware there is a forum. I'm not good with Excel so this a very helpful. I reviewed your res...

3 years ago