I'm attempting to restructure a table with another table.
How would you do the following???
All Clock IN's from TblA in TblB Clock In column and Clock OUT's in the Clock OUT columns
This would also need to line up the appropriate Employee ID. I've also attached a macro enabled example file for testing
|Time IN or Out||Employee ID||INorOUT|
|10/9/20 6:00 AM||1212||Clock IN|
|10/9/20 6:30 AM||2323||Clock IN|
|10/9/20 6:00 PM||1212||Clock OUT|
|Employee ID||Clock IN||Clock OUT|
|1212||10/9/20 6:00 AM||10/9/20 6:00 PM|
|2323||10/9/20 6:30 AM||etc..|
I appreciate any help with this.