Hi,
I have a below table of Content
CUSTOMER ID QUESTIONS ANSWER
1 FirstName John
1 LastName William
1 Country India
1 Zip Code 60000
2 FirstName xxxx
2 LastName yyyy
2 Country US
2 Zip Code 123456
3 OrgName ABC Pvt Ltd
3 Country UK
3 Zip Code 987654
I want to convert this row of data into single row group by Customer ID as mentioned below,
Customer Id First Name Last Name Org Name Country Zip Code
1 John William India 60000
2 xxxx yyyy US 123456
3 ABC Pvt Ltd UK 987654
kinldy let me know how can I achieve this.
Thanks in Advance.