Need to have data on one line...
Hi I need to have data below appear on columns across the page. I'm not counting, or summarizing anything so I'm not sure if the pivot command can help me. Another requires is a "persons" the tasks can change so my column number will change as well. Can someone help me?
Person Task Rating
106011 Analysis/Problem Solving 2
106011 Communication D
106011 Ethics and Integrity
106011 Workload Management D
106011 Action Orientation 3
106011 Coaching
106011 Judgment
Query below...
SELECT pp.participation_in_id,
pct.name,
prl.step_value
FROM per_competence_elements pce ,
per_all_people_f pap ,
per_competences_tl pct ,
per_participants pp ,
per_rating_levels prl ,
0