Do you have any blank rows in the data?
Yes, I do have a few empty rows or missing data, here is what 2 rows look like, this is the original, i managed to clean it up prior, but at this rate, i can go with the information below:
[TABLE="width: 4367"]
<colgroup><col><col span="4"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Sku[/TD]
[TD]Dim.1[/TD]
[TD]Dim.2[/TD]
[TD]Dim.3[/TD]
[TD]Dim.4[/TD]
[TD]Store[/TD]
[TD]Description[/TD]
[TD]Vendor[/TD]
[TD]Department[/TD]
[TD]Product Number[/TD]
[TD]QTYAVL[/TD]
[TD]QOH[/TD]
[TD]SOLD[/TD]
[TD]COMIT[/TD]
[TD]QOO[/TD]
[TD]SO[/TD]
[TD]QTBP[/TD]
[TD]RECV[/TD]
[TD]TRAN[/TD]
[TD]OT[/TD]
[TD]IT[/TD]
[TD]ADJ[/TD]
[TD]Min[/TD]
[TD]Max[/TD]
[TD]QROP[/TD]
[TD]Lookups[/TD]
[TD]Dim.1 Group[/TD]
[TD]Dim.1 Description[/TD]
[TD]Dim.2 Group[/TD]
[TD]Dim.2 Description[/TD]
[TD]Dim.3 Group[/TD]
[TD]Dim.3 Description[/TD]
[TD]Dim.4 Group[/TD]
[TD]Dim.4 Description[/TD]
[TD]In Store Location[/TD]
[TD]Price[/TD]
[TD]ListCost[/TD]
[TD]AvgCost[/TD]
[TD]Brand[/TD]
[TD]Season[/TD]
[TD]Bin Picking#[/TD]
[TD]Tax1[/TD]
[TD]Tax2[/TD]
[TD]Tax3[/TD]
[/TR]
[TR]
[TD="align: right"]8024[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]True Terpenes .5ml Ceramic Cartridge White[/TD]
[TD]True Terpenes[/TD]
[TD]Extraction[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]19192[/TD]
[TD="align: right"]4830[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]-1100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]122[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$0.99[/TD]
[TD="align: right"]$0.80[/TD]
[TD="align: right"]$0.80[/TD]
[TD]True Terpenes[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6258[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cartridge Plastic Containers .5 ml ::$0.25[/TD]
[TD]Ypsilanti Oil Company[/TD]
[TD]Extraction[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]17042[/TD]
[TD="align: right"]31327[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]54000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5631[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$0.25[/TD]
[TD="align: right"]$0.12[/TD]
[TD="align: right"]$0.11[/TD]
[TD]$$$[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]