Hello,
By chance, have you helped anyone with pivoting data into a grid?
I have some data that looks similar to this::
EmployeeID | ShiftDate (MMddyyyy) | Hours
1 | 11062021 | 07:00 - 10:00
1 | 11072021 | 08:00 - 12:00
1 | 11082021 | 07:00 - 10:00
1 | 11092021 | 07:30 - 16:00
2 | 11062021 | 07:00 - 10:00
2 | 11072021 | 07:00 - 10:00
2 | 11092021 | 07:00 - 10:00
3 | 11082021 | 07:00 - 10:00
I'd like to show it in the Grid Like this:
EmployeeID | 11062021 | 11072021 | 11082021 | 11092021 |
1 | 07:00 - 10:00 | 08:00 - 12:00 | 07:00 - 10:00 | 07:30 - 16:00 |
2 | 07:00 - 10:00 | 07:00 - 10:00 | | 07:00 - 10:00 |
3 | | | 07:00 - 10:00 | |
Hoping for an example if possible. Since this product doesn't have the PivotGrid, I might have to come up with another idea.
Sincerely,
Keith Nicholson