I have done a cut & paste of a list from the web/library page. It has a
lot of stuff that I don't need. I could go through it manually and
delete everything I don't need, but that may take days. I am wondering
if there is a way to do it quickly and easily using some sort of code
or filters or whatever. In the end all I really need is the company
info one cell under another and then a single space and then repeat
using the next companies info and so on. I posted the origial file
along with a small sampling (done manually) of what I would like to
achieve at the URL below. Thanks in advance for any help offered.
http://excelexample.homestead.com/index.html