Forum Discussion
Form data conversion to pivot table
I have a form that asked which agency are you having an issue with? The results come back as follows:
DOEA DCF ADRC
Off Yes Off
Off Yes Yes
I want the pivot table to show me the number of Yes responses for each of the three options. However, I believe the responses being "off" (meaning it wasn't selected) or "Yes" (it is an issue) doesn't convert in excel. Is this a form issue I need to correct? Is this a formula I need to understand in Excel? I would appreciate any suggestions.
You may do that with help of Power Query
- query source and unpivot columns
- land result back to the grid as PivotTable
3 Replies
You may do that with help of Power Query
- query source and unpivot columns
- land result back to the grid as PivotTable
SergeiBaklan I appreciate you sending that. I had to jump over and do a little research on unpivot as this is all new to me (way outside my normal daily work); however, I do believe that is what I was missing.
Thank you!
Jason
JasonPcolaElderLaw , glad to help
