Create wide columns from a deep table

[H1999]

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

[Luke_C]

Hi @H1999 

The crosstab tool should do the trick. See below and attached. Maybe there's something wrong in how you configured it?

[H1999]

Hi @Luke_C

Thank you for your response. I think it also needs a unique button to remove repetitive id's and filter button

[Luke_C · Accepted solution]

Hi @H1999 

Sure, Added those tools (Filter tool, Unique Tool). See attached. Your sample data does not contain these scenarios so please check and mark as the solution if it works.

[H1999]

Thanks, that works