2021-06-29

Combining multiple rows into one based on timestamps with varying number of rows

I am using a barcode scanner to input data for production runs and downtime. The idea is to scan the job number in, start the job, and scan the job number out when finished. Within some of the jobs there may be downtime such as equipment malfunction or a scheduled break. These will also have barcodes for the operator to scan.

I want there to be a single row where the part number is scanned in, any downtime codes scanned before the end of the current job are captured in the row as well, and the scan out completes the entire process and drops to the next row to await the start of the next job.

So far I am able to scan the barcode to show the job number or downtime code and the time it is scanned. Scan code is shown in column A, Time is shown in Column B.



from Recent Questions - Stack Overflow https://ift.tt/3xXmlm4
https://ift.tt/eA8V8J

No comments:

Post a Comment