I have a table that houses training information, essentially
date, training time, and training event. I am trying to create a
cfgrid that will transpose it into a grid with training time as the
vertical axis and date as the horizontal axis, with the appropriate
training event inside the grid, like this:
9/15 9/16 9/17 9/18 ...
0600-1000 Group A Tng X Group A Tng Y Group A Tng Z Group A
Final Exam ...
1000-1400 Group B Tng A Group B Tng B Group B Tng C Group C
Tng A ...
It's essentially a pivot table grouped on training time and
date, but I cannot seem to get it to work in CF MX7. Any ideas?