Hi,
Attached is an excel file with a lot of data (and more columns to come). I need help organizing all of this data and choosing the best way to do so (Ideally this can be done in a way that is easy to read.). I'm wondering if a pivot table is the way to go, and if so, please help me set it up.
I have to:
1) Group by Industry (column P).
2) Compile average/median stats for each of the industry groups. (I will be adding many more columns)
3) exclude those in column Z with an X.
One suggestion: Having a summary that collapses below each sector, and then a summary of the sectors at the top or bottom.
What is the smartest way to set this up that also makes sense given the layout?
Thank you!!
Bookmarks