Data Table Transformation in Qliksense

[samuel_lin]

Hi Qlikers,

it's really hard to describe in the discussion subject what I am trying to do.

Here's a photo:

I have a table with two columns, one is OrderNumber and the other is Products.

I want to transform it to a table with distinct OrderNumber, and a list of products for that OrderNumber in the columns.

Is there a way to accomplish this in Qliksense? load scripts?

any idea?

Thanks,

[Anonymous]

Thanks! It was exactly what I'm looking for.