How to move cursor to next column for barcode entries (2 column) then to next row?

Hi,
I am a beginner in excel.
Joining this forum in hope to have solve this problem of mine.
Thank you.

I have a scanned txt (or xls) files which are per following from the barcode scanner output:
91100001
20
91100002
15
91100003
2

I need to output it into csv or xls in such:
Barcode (Col A) Qty (Col B)
91100001 20
91100003 15
91100003 2


Your help will be much appreciated.

Copy the following into a code module, select your data sheet and run the Tabulate macro.

Please Login or Register  to view this content.