I am trying to flatten the data using the below query but somehow I am unable to achieve the desired output. Kindly suggest where I am going wrong. Desired Output : Column 1 Column 2 Column 3 IT Sachin Karunadu Application Developer IT John Doe System Analyst HR Jane Smith HR Manager
