Hi there,
I have a report, its a list of employee punches that I want to consolidate. Theres a new row for each punch, which I dont want.
I would like a code so that if it finds the same employee ID, it would put the next Punch Time into Punch Time 2, and if it finds another, into Punch Time 3 and so forth.
There would be approximately 10,000+ rows, not sure if excel has trouble handling such high volume data and if it would take long?
I have a report, its a list of employee punches that I want to consolidate. Theres a new row for each punch, which I dont want.
Book1 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | BALANCE DATE | FIRST NAME | LAST NAME | EMPLOYEE ID | SHIFT | FCLM AREA | Manager ID | PUNCH DATE | PUNCH TIME | SITEID | USERNAME | SERVER | SOURCE SYSTEM | ||
2 | 03/12/2021 | 102989383 | DH5C0700 | 3 - | 109209241 | 03/12/2021 | 06:51:00 AM | ||||||||
3 | 03/12/2021 | 109064517 | DC4C0700 | 3 - | 106928187 | 03/12/2021 | 07:03:00 AM | ||||||||
4 | 03/12/2021 | 105016027 | DB0CACOM | 3 - | 109209241 | 03/12/2021 | 07:08:00 AM | ||||||||
5 | 03/12/2021 | 109399457 | DB3C0700 | 3 - | 109209241 | 03/12/2021 | 07:00:00 AM | ||||||||
6 | 03/12/2021 | 109154451 | DB3C0700 | 3 - | 109209241 | 03/12/2021 | 07:00:00 AM | ||||||||
Sheet1 |
I would like a code so that if it finds the same employee ID, it would put the next Punch Time into Punch Time 2, and if it finds another, into Punch Time 3 and so forth.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | EMPLOYEE ID | PUNCH TIME 1 | PUNCH TIME 2 | PUNCH TIME 3 | PUNCH TIME 4 | PUNCH TIME 5 | PUNCH TIME 6 | ||
2 | |||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
Sheet2 |
There would be approximately 10,000+ rows, not sure if excel has trouble handling such high volume data and if it would take long?