Hi,
In have a dataset of more than 14000 records, barcodes.
Al these barcodes are packed in boxes. The boxes are labeled.
With help of the pivot function I can create a table which contains:
Box number and all barcodes per boxes. Unfortunately this will not help because we search via barcodes.
My question does anybody knows a way to get the following layout:
Barcode Location 1 Location 2 etc
Find below some printscreen of the dataset and the pivot we created:
DATASET
http://imageshack.us/photo/my-images/20/schermafbeelding2011093.png/
PIVOT
In have a dataset of more than 14000 records, barcodes.
Al these barcodes are packed in boxes. The boxes are labeled.
With help of the pivot function I can create a table which contains:
Box number and all barcodes per boxes. Unfortunately this will not help because we search via barcodes.
My question does anybody knows a way to get the following layout:
Barcode Location 1 Location 2 etc
Find below some printscreen of the dataset and the pivot we created:
DATASET
http://imageshack.us/photo/my-images/20/schermafbeelding2011093.png/
PIVOT
