Forum Discussion
Solved
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 Y...
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