Dear Team,
i stuck a requirement that how to create a next row in new field.
requirement is below table
| Date | Name | Shift in | Shift Out |
| 01-04-18 | A | 7:00:00 | 13:00:00 |
| 02-04-18 | A | 8:00:00 | 14:00:00 |
| 03-04-18 | A | 9:00:00 | 15:00:00 |
| 04-04-18 | A | 10:00:00 | 16:00:00 |
| 05-04-18 | A | 11:00:00 | 17:00:00 |
| 01-04-18 | B | 7:00:00 | 13:00:00 |
| 02-04-18 | B | 8:00:00 | 14:00:00 |
| 03-04-18 | B | 9:00:00 | 15:00:00 |
| 04-04-18 | B | 10:00:00 | 16:00:00 |
| 05-04-18 | B | 11:00:00 | 17:00:00 |
| 01-04-18 | C | 7:00:00 | 13:00:00 |
| 02-04-18 | C | 8:00:00 | 14:00:00 |
| 03-04-18 | C | 9:00:00 | 15:00:00 |
| 04-04-18 | C | 10:00:00 | 16:00:00 |
| 05-04-18 | C | 11:00:00 | 17:00:00 |
| 01-04-18 | D | 7:00:00 | 13:00:00 |
| 02-04-18 | D | 8:00:00 | 14:00:00 |
| 03-04-18 | D | 9:00:00 | 15:00:00 |
| 04-04-18 | D | 10:00:00 | 16:00:00 |
| 05-04-18 | D | 11:00:00 | 17:00:00 |
| 01-04-18 | E | 7:00:00 | 13:00:00 |
| 02-04-18 | E | 8:00:00 | 14:00:00 |
| 03-04-18 | E | 9:00:00 | 15:00:00 |
| 04-04-18 | E | 10:00:00 | 16:00:00 |
| 05-04-18 | E | 11:00:00 | 17:00:00 |
And Output is
| Date | Name | Shift in | Shift Out | NEXT IN | NEXT OUT |
| 01-04-18 | A | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
| 02-04-18 | A | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
| 03-04-18 | A | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
| 04-04-18 | A | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
| 05-04-18 | A | 11:00:00 | 17:00:00 | | |
| 01-04-18 | B | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
| 02-04-18 | B | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
| 03-04-18 | B | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
| 04-04-18 | B | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
| 05-04-18 | B | 11:00:00 | 17:00:00 | | |
| 01-04-18 | C | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
| 02-04-18 | C | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
| 03-04-18 | C | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
| 04-04-18 | C | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
| 05-04-18 | C | 11:00:00 | 17:00:00 | | |
| 01-04-18 | D | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
| 02-04-18 | D | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
| 03-04-18 | D | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
| 04-04-18 | D | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
| 05-04-18 | D | 11:00:00 | 17:00:00 | | |
| 01-04-18 | E | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
| 02-04-18 | E | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
| 03-04-18 | E | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
| 04-04-18 | E | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
| 05-04-18 | E | 11:00:00 | 17:00:00 | | |
KINDLY TELL ME HOW TO USE PEEK WITH IF STATEMENT IN ABOVE REQUIREMENT
For This i am attaching excel file for row data in sheet 1
and
sheet 2 is result part
