Forum Discussion
How to summarize data in multiple columns
I have 15 columns named [event1] through [event15]. In each column, the user selected an item from a dropdown (in the database). The list of items is exacly the same for every event. So, [event1] , [...
Hi Anonymous ,
Maybe you can consider to use unpivot columns feature to merge these fields, then you can simply use formula to summary multiple attribute fields based on condition
Unpivot Data Using Excel Power Query
Regards,
Xiaoxin Sheng
Hi Anonymous ,
Maybe you can consider to use unpivot columns feature to merge these fields, then you can simply use formula to summary multiple attribute fields based on condition
Unpivot Data Using Excel Power Query
Regards,
Xiaoxin Sheng
That is EXACTLY what I needed! Thank you so much!