Hello, I want to convert this:
Excel 2016 (Windows) 32 bit
to this:
Excel 2016 (Windows) 32 bit
Excel 2016 (Windows) 32 bit
Name | Date | Hours |
Bob | 1/1/2017 | 4.5 |
Bob | 1/1/2017 | 3.5 |
Bob | 1/2/2017 | 4.5 |
Bob | 1/2/2017 | 5 |
Mary | 1/1/2017 | 3.5 |
Mary | 1/1/2017 | 3 |
Mary | 1/2/2017 | 6 |
Mary | 1/2/2017 | 2.5 |
Sheet: Sheet1 |
to this:
Excel 2016 (Windows) 32 bit
Name | Date | Hours |
Bob | 1/1/2017 | 8 |
Bob | 1/2/2017 | 9.5 |
Mary | 1/1/2017 | 6.5 |
Mary | 1/2/2017 | 8.5 |
Sheet: Sheet1 |