Rearange an inventory sheet or scan it to the wanted arangement.

Hello Guru's,

During an inventory action we will be swapping old devices for new ones and we will be using a barcodereader for gathering the devicenumbers in multiple Excel sheets. The barcode scanner places the scanresults in 1 column. In every sheet this column will contain as first entry the name of the building followed by a room number. Next entry wil be the devicenumbers of the old and the new device, the number of devices per room is variable.

So the column would look like Buildingname; roomnumber; old device; new device; old device; new device; room number; old device; new device; room number; old device; new device; old device; new device; old device; new device; roomnumber; old device; new device etc...

What we need is the devices being split up into two collumns with the roomnumber behind them. Old devices in column A; new devices in Column B; building and roomnumbers in column C.

Is that possible in Excel without getting complex?

An example sheet of the barcode scanresults and the wanted results is attached.

Any tips on creating the wanted results with the barcodescanner are also welcome!

Sorry for my late reaction MickG. I've been ill for a while and a collegue solved this issue on a totaly different and more expencive way. I'll consider this solved.