Precital som to cele. Vyplyva z toho, ze sa to da zoradit len podla par logickych podmienok (napr. od A po Z...). Ale ja si chcem zachovat take nekonformne poradie ake mam (neda sa to obsiahnut hentymi podmienkami).

Urobil som to takto:
http://www.theexceladdict.com/_t/t031008.htm

To co on pise ze: "You could filter the list for blanks, select these rows (i.e. visible cells) and delete them.", to je toto Metoda 3:
http://www.exceltrick.com/how_to/delete-blank-rows -in-excel/
lenze ja to nemam v 2010, je to len v 2013 office.

Potom som este skusal toto:
http://www.howtogeek.com/206696/how-to-quickly-and -easily-delete-blank-rows-and-columns-in-excel-201 3/
ale v 2010 to zmaze aj riadky ktore maju vnutri iba jednu blank bunku, teda nie cele blank rows. Tak ako tuto Metoda 1, Metoda 2:
http://www.exceltrick.com/how_to/delete-blank-rows -in-excel/