I imported some information from a web page and when it loaded it has huge
amounts of blank rows, how can I delete these without doing each small bunch
of rows individually. Ex: I have the company name and then 12 rows later I
get the phone number then five rows later there is the address. I might add
that it is not uniform in any way now of the blanks row amounts are the same.
All total there should be 101 company entries that should take up about 404
rows, but instead it takes up 19822. Oh and all this information is only in
column A (which is OK but most of your help answers say I need more than one
column of data). Please help, I know there has to be an easier way. I hope
that you understand this as it is hard to explain.
--
VRaybandb