How to remove duplicates and blank cells from data in Excel

Dataset: lyrics of the song "Happy together" by The Turtles

00:12 — Import csv file, comma as delimiter
00:47 — Clear formats
1:10 — Convert table to range
1:28 — Removing duplicates
1:58 — Options "Expand the selection" and "Continue with the current selection"
2:40 — Fake blank cells: what to do, if the cells appear to be blank, but are not in fact. How to spot and remove fake blank cells
4:36 — Removing of actual blank cells
5:10 — F5 + Special VS Find & Select + Go to Special

Video created by Maria Kasakowa (undine_su_menulio)