Spreadsheet: 118597d1313777839-excel-2007-how-do-i-remove-empty-cells-in-a-range-example-2
Sheet: Sheet1

 | Amazon | [NAME] | [NAME] | [NAME] | Dwarf | Elf | Goblin | Halfling | High Elf | Human | Khemri | Lizardman | Necromantic | Norse | [NAME] | Ogre | Orc | Skaven | Undead | Vampire | Wood Elf | Trollkin | Slaanesh | Tzeentch | Khorne | Slaan | Chaos Pact | Underworld | [NAME] | Bretonnian
Amazon Linewoman | 16
Amazon Thrower | 2
Amazon Catcher | 2
Amazon Blitzer | 4
Gor |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Chaos Warrior |  | 4
Minotaur |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Chaos [NAME] |  |  | 6
Hobgoblin |  |  | 16
Bull Centaur |  |  | 2
[NAME] |  |  |  | 16
[NAME] |  |  |  | 2
[NAME] |  |  |  | 2
[NAME] |  |  |  | 4
Witch Elf |  |  |  | 2
Longbeard |  |  |  |  | 16
[NAME] |  |  |  |  | 2
[NAME] |  |  |  |  | 2
[NAME] |  |  |  |  | 2
Deathroller |  |  |  |  | 1
[NAME] |  |  |  |  |  | 16
Elf Thrower |  |  |  |  |  | 2
Elf Catcher |  |  |  |  |  | 4
Elf Blitzer |  |  |  |  |  | 2
Goblin |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  | 4
[NAME] |  |  |  |  |  |  | 1
Goblin Fanatic |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  | 1
Troll |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 1
Halfling |  |  |  |  |  |  |  | 16
Treeman |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1
High Elf Line-Elf |  |  |  |  |  |  |  |  | 16
Pheonix Warrior |  |  |  |  |  |  |  |  | 2
Lion Warrior |  |  |  |  |  |  |  |  | 4
Dragon Warrior |  |  |  |  |  |  |  |  | 2
Human Lineman |  |  |  |  |  |  |  |  |  | 16
Human Catcher |  |  |  |  |  |  |  |  |  | 4
Human Thrower |  |  |  |  |  |  |  |  |  | 2
Human Blitzer |  |  |  |  |  |  |  |  |  | 4
Ogre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1
Skeleton |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  | 16
[NAME] |  |  |  |  |  |  |  |  |  |  | 2
Blitz-Ra |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  | 4
Skink |  |  |  |  |  |  |  |  |  |  |  | 16
Saurus |  |  |  |  |  |  |  |  |  |  |  | 6
Kroxigor |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  | 16
Ghoul |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 4
Wight |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2
Flesh Golem |  |  |  |  |  |  |  |  |  |  |  |  | 2
Necromantic Werewolf |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Norse Thane |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Berserker |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Ulfwerener |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Yhetee |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Rotter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Pestigor |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Nurgle Warrior |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Beast of Nurgle |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Snotling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Orc Grunt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Orc Thrower |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Black Orc Blocker |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Orc Blitzer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Clanrat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Stormvermin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2
Rat Ogre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Thrall |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Vampire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Wood Elf Lineman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Wood Elf Catcher |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Wood Elf Thrower |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Wardancer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Slaan Linefrog |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
[NAME] |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Clanrat Renegade |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Chaos Troll |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Underworld Goblin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Warpstone Troll |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Dryad |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Ungor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Bestigor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Knight of the Line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Knight of the Field |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Squire of the Line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Squire of the Field |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Peasant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
[NAME] |  |  |  |  | x
[NAME] | x |  |  |  |  |  |  | x |  |  |  |  |  |  |  | x
Brick Far'th and [NAME] Far'th |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x | x
Brick Far'th and Grotty - Grotty |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x | x
Bomber Dribblesnot |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x | x
[NAME] |  |  |  |  | x |  |  |  |  |  |  |  |  | x
Count Luthor Von Drakenborg |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x | x
Crazy Igor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Deeproot Strongbranch |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  | x |  |  | x |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  | x |  | x |  |  | x |  |  |  |  |  |  |  |  |  |  |  | x
Fezglitch |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Flint Churnblade |  |  |  |  | x
Fungus the Loon |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  | x | x |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  | x
Hack Enslash |  |  |  |  |  |  |  |  |  |  | x |  | x |  |  |  |  |  | x
Hakflem Skuttlespike |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Headsplitter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Helmut Wulf | x |  |  |  |  |  |  |  |  | x |  | x |  | x |  |  |  |  |  | x
Hemlock |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  | x
Hthark the Unstoppable |  |  | x
[NAME] |  |  |  | x |  | x
Humerus Carpal |  |  |  |  |  |  |  |  |  |  | x
Icepelt Hammerblow |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Ithaca Benoin |  |  |  | x |  |  |  |  |  |  | x
J Earlice |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x | x
[NAME] |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x
Lord [NAME] Despoiler |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x
Lottabottol |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  | x
Morg 'n' Thorg | x | x | x | x | x | x | x | x | x | x |  | x |  | x | x | x | x | x |  | x | x
[NAME] |  |  | x |  |  |  | x |  |  |  |  |  |  |  |  | x
Prince Moranion |  |  |  |  |  | x |  |  | x
[NAME] |  |  |  |  |  |  |  | x |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  | x
Ramtut III |  |  |  |  |  |  |  |  |  |  | x |  | x |  |  |  |  |  | x
[NAME] |  |  | x
[NAME] |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | x
[NAME] | x |  |  | x
Scrappa Sorehead |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x | x
Setekh |  |  |  |  |  |  |  |  |  |  | x |  | x |  |  |  |  |  | x
Silbil |  |  |  |  |  |  |  |  |  |  |  | x
Sinnedbad |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  | x
[NAME] | x |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x
[NAME] | x |  |  |  | x |  |  | x | x | x |  |  |  | x |  |  |  |  |  |  | x
[NAME] |  |  | x