Spreadsheet: 150635d1334635690-help-with-getting-rid-of-0s-in-spreadsheet-dota-2-log-example
Sheet: Sheet1

Games |  |  |  |  |  |  |  |  |  |  | Hero Totals |  |  |  |  |  |  |  |  |  |  | Hero Averages |  |  |  |  |  |  |  | Game Totals
Date | Hero | Primary | End LvL | Kill | Death | Assist | CS | Deny | W/L |  | Hero | Primary | Games | W | L | Kills | Deaths | Assists | CS | Deny |  | Hero | Kill | Death | Assists | CS | Deny | End LvL |  | Games | W | L | Kills | Deaths | Assists | CS | Deny
2012-03-24 00:00:00 | [NAME] | Str | 13 | 2 | 8 | 0 | 55 | 7 | L |  | Abaddon | Str
2012-03-24 00:00:00 | Mirana | Agi | 21 | 9 | 10 | 14 | 164 | 16 | L |  | Alchemist | Str |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game Total Averages
2012-03-24 00:00:00 | Mirana | Agi | 23 | 5 | 14 | 18 | 174 | 15 | L |  | Ancient Apparition | Int |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Games | W | L | Kills | Deaths | Assists | CS | Deny | End LvL
2012-03-24 00:00:00 | [NAME] | Str | 25 | 13 | 5 | 13 | 177 | 8 | W |  | Anti-Mage | Agi
2012-03-25 00:00:00 | [NAME] | Str | 16 | 2 | 9 | 3 | 72 | 6 | W |  | Axe | Str
2012-03-25 00:00:00 | Weaver | Agi | 25 | 14 | 4 | 13 | 263 | 10 | W |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Batrider | Int
 |  |  |  |  |  |  |  |  |  |  | Beastmaster | Str
 |  |  |  |  |  |  |  |  |  |  | Bloodseeker | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Bristleback | Str
 |  |  |  |  |  |  |  |  |  |  | Broodmother | Str
 |  |  |  |  |  |  |  |  |  |  | Centaur Warchief | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Clinkz | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Crystal Maiden | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Dazzle | Int
 |  |  |  |  |  |  |  |  |  |  | Death Prophet | Int
 |  |  |  |  |  |  |  |  |  |  | Dirge | Str
 |  |  |  |  |  |  |  |  |  |  | Disruptor | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Dragon Knight | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Earthshaker | Str
 |  |  |  |  |  |  |  |  |  |  | Enchantress | Int
 |  |  |  |  |  |  |  |  |  |  | Enigma | Int
 |  |  |  |  |  |  |  |  |  |  | Faceless Void | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Gyrocopter | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Keeper of the Light | Int
 |  |  |  |  |  |  |  |  |  |  | Kunkka | Str
 |  |  |  |  |  |  |  |  |  |  | Lanaya | Agi
 |  |  |  |  |  |  |  |  |  |  | Leshrac | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Lifestealer | Str
 |  |  |  |  |  |  |  |  |  |  | Lina | Int
 |  |  |  |  |  |  |  |  |  |  | Lion | Int
 |  |  |  |  |  |  |  |  |  |  | Lone Druid | Str
 |  |  |  |  |  |  |  |  |  |  | Luna | Agi
 |  |  |  |  |  |  |  |  |  |  | Lycanthrope | Str
 |  |  |  |  |  |  |  |  |  |  | Magnataur | Str
 |  |  |  |  |  |  |  |  |  |  | Medusa | Agi
 |  |  |  |  |  |  |  |  |  |  | Meepo | Agi
 |  |  |  |  |  |  |  |  |  |  | Mirana | Agi
 |  |  |  |  |  |  |  |  |  |  | Morphling | Agi
 |  |  |  |  |  |  |  |  |  |  | Mortred | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Nature's Prophet | Int
 |  |  |  |  |  |  |  |  |  |  | Necrolyte | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Night Stalker | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Omniknight | Str
 |  |  |  |  |  |  |  |  |  |  | Outworld Destroyer | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | Phoenix | Int
 |  |  |  |  |  |  |  |  |  |  | Pit Lord | Str
 |  |  |  |  |  |  |  |  |  |  | Puck | Agi
 |  |  |  |  |  |  |  |  |  |  | Pudge | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Queen of Pain | Int
 |  |  |  |  |  |  |  |  |  |  | Razor | Agi
 |  |  |  |  |  |  |  |  |  |  | Riki | Agi
 |  |  |  |  |  |  |  |  |  |  | Rubick | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Shadow Demon | Int
 |  |  |  |  |  |  |  |  |  |  | Shadow Fiend | Agi
 |  |  |  |  |  |  |  |  |  |  | Shadow Shaman | Int
 |  |  |  |  |  |  |  |  |  |  | Silencer | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Slardar | Str
 |  |  |  |  |  |  |  |  |  |  | Slark | Agi
 |  |  |  |  |  |  |  |  |  |  | Sniper | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int
 |  |  |  |  |  |  |  |  |  |  | Spectre | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Storm Spirit | Int
 |  |  |  |  |  |  |  |  |  |  | Sven | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] Chieftan | Str
 |  |  |  |  |  |  |  |  |  |  | Tidehunter | Str
 |  |  |  |  |  |  |  |  |  |  | Tinker | Int
 |  |  |  |  |  |  |  |  |  |  | Tiny | Str
 |  |  |  |  |  |  |  |  |  |  | Treant Protector | Str
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Agi
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Str
 |  |  |  |  |  |  |  |  |  |  | Ursa | Agi
 |  |  |  |  |  |  |  |  |  |  | Vengeful Spirit | Agi
 |  |  |  |  |  |  |  |  |  |  | Venomancer | Agi
 |  |  |  |  |  |  |  |  |  |  | Viper | Agi
 |  |  |  |  |  |  |  |  |  |  | Visage | Int
 |  |  |  |  |  |  |  |  |  |  | Warlock | Int
 |  |  |  |  |  |  |  |  |  |  | Weaver | Agi
 |  |  |  |  |  |  |  |  |  |  | Windrunner | Int
 |  |  |  |  |  |  |  |  |  |  | Witch Doctor | Int
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Int