New to Qlik Sense

[D19PAL]

Hi Guys,

I need the following, I know its probably cross table or generic, I need the syntax too thanks lol.

How it is

ID,question,answer

1,2,x

1,3,y

1,4,x

2,2,x

2,3,y

2,4,x

I want it like this

1D,q2,q3,q4

1,x,y,x

2,xyx

I need it in a backend table, not a pivot table.

Thanks