Create a pseudo-pivot query for a report
Posted on 2013-11-13
I have table with widgets and a table with tasks. Each widget has one of each of the tasks, none get left out.
The tables look something like so:
Currently I can run a query on tblWorkflow and see my data like so:
Widget ID Task ID Completion_Date
1 1 1/1/13
1 2 1/2/13
2 1 3/1/13
2 2 3/2/13
However, I'd like to create a query that pivots the data so all my task names are listed horizontally across the top and my widgets are listed vertically on the side like so:
Widget ID Task #1 Task #2 Task #3
1 1/1/13 1/2/13 1/3/13
2 3/1/13 3/2/13 3/3/13
The results should dynamically pick up any new tasks as they are added so they don't need to be added manually.
Thanks in advance.