I'm trying to create wide column from a deep table, and removing id's if both occupation and address are nulls. i tried using crosstab, and filter but not getting the exact result.
Table looks like below
id Field value
1 phone_no 800-000-0002
1 address 827 lambert street
1 occupation student
2 phone_no 800-393-9999
2 address 222 Abbey Street
2 occupation Null
2 Hobby Soccer
I want it like below
id phone no occupation address Hobby
1 800-000-000 student 827 lambert street Null
2 800-393-9999 Null 222 Abbey Street Soccer
