Hey guys, working on a project this summer, rebuilding an excel book.

One of the first steps is taking the upstream data and merging it into our own sheet.

The trick is, the upstream data is pretty bad. Its a result of years of product mix changes, and as products were discontinued, they just put dashes through their row. Meanwhile when new products are added, they just tack it on where ever they want. Its ugly, its wasteful, its confusing, its beyond my control. (even if I got them to clean the file, Im sure it would just start over from then)

My hope is to avoid manual intervention.

What Im envisioning is some system that will scan a column (known) for basicly anything other than a "-", and copy that row over. Proceeding down the list... filtering out all the blank rows.

I know I could just sort the raw data, but my ideal solution is to just copy the tab into the workbook, and produce a nice consolidated product without any manipulation. Preferably the computer will know to sort and copy without user intervention

Is it possible?