This content has been marked as final. Show 5 replies
I am a loading a table from sql. The query is like this:
Select Year, Product, Bookings from BookingTable
There are 5 distinct products:
ProductA ProductB, etc.
From this table I want to make a table that has Year, and the distinct Product Names as the columns.
So it would look like:
Year, ProductA, ProductB, ProductC...
2011 $1 $2 $3
Anyone know if this is possible?