Stock inventory cout with serial numbers sorting query

[smeeagain1]

Hi guys. I have a scanner that scans stock barcodes and serial numbers into a memory chip on the scanner.I then dock the scanner and download the info into excel.
I need to sort the data into 2 columns based on cell contents.

If I scan an item without a serial number, I just want it to stay in column A, however, if I scan a serialized item (ie: scan the barcode and then scan the serial number), I need Excel to take that serial and place it in column B next to the items barcode entry (ie: move the serial up one line and into column B).
Also I need to then remove the blank line from the sheet.
The items scanned have a Product number (denoted by a P-####) when scanned, so I could differentiate the serials and products using this delimiter. Can anyone assist please?
Thanks.


******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;">******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[smeeagain1]

Howard,

That looks like it fixed it. I will test with a large data set and let you know how that goes.
I would like to express my sincerest gratitude for all your assistance here and want you to know that your efforts are truly appreciated.
I could never have achieved this without your help.

i will report back with final tests and again, thank-you very much.

******** type="cosymantecnisbfw" cotype="cs" id="SILOBFWOBJECTID" style="width: 0px; height: 0px; display: block;"></object>

 

[L. Howard]

Okay, great. Hope the testing goes well.

Of course you will notice the code is '/ by Claus.

Regards,
Howard