yogi_Pull Only Those Column Of Table Where Not All Rows of a Column Are Equal To Zero

Google Spreadsheet   Post  #2186

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-18-2017

question by BgibbzGaminh:

https://productforums.google.com/forum/#!topic/docs/KStTTxnUdFc;context-place=forum/docs
Table Simplfier Function

Hi, so I do stats for a small time E-sports league, and I'm looking for away to condense player character selection tables. Essentially, I have a table of players and characters, recording the frequency that each player selects a character. However, many characters don't get selected. I want to create a formula to regenerate the table while only including columns that have a sum greater than 0 (Only include characters that were selected).

Linked below is sample doc showing what I would like to do.

https://docs.google.com/spreadsheets/d/1Vb-98vdbBTN9rEg4Mv-0VlxhGxUC7UMeAvrCABut-iY/edit?usp=sharing