I have a query results like this:
Name Level Key Description Jannuary February
Peter 3 P Peter's Sales 500 200
Isabel 3 P Isa's Sales 200 450
How could I do a new query the results be like this :
Key Peter Jan Peter Feb Isa Jan Isa Feb
P 500 200 200 450
(since both lines on first query was P) there is only 1 row on second query result and Vendors are horizontal. If there were 5 months they would have 5 months each...
is it possible ? ... thanks sql experts !!