Hi Chris,

I just looked at this again and I am glad that I did!

You can use pivot tables in a slightly stange way but it won't tell you
anywhere how to....

if you create a pivot table on your data and have barcode as your row and
quantity in both colum and Data.

This will give you the following:
AA 2 44
DD 7 12
KK 9


If you copy the table (without any totals or column headings and paste the
values into a new sheet, select all of your new data and run the code below
it will move everything along for you....NB: You may have to run this a
couple of times to get it all correct.

Sub deletetheblanks()
For Each Cell In Selection
If Cell.Value = "" Then
Cell.Delete Shift:=xlToLeft
End If
Next Cell
End Sub


HT is of more H!

Simon

chrisnichols87 wrote:
I'm trying to set up a barcode reader, which uploads enetered data into
an excel spreadsheet. The data is copied into excel in sererate
records, but I am struggling to figure out a way to group seperate
records into one single record if they have the same barcode number.
E.g:

Barcode Quantity
AA 2
DD 7
KK 9
AA 44
DD 12

I want this to be automatically changed to:

Barcode QuantityA QuantityB QuantityC
AA 2 44
DD 7 12
KK 9

Is this even possible???

Any help would be appreciated!!!

Thanks,
Chris

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1