Transpose / Pivot table front end Qlik sense

[pascos88]

table:

Company     Text    Comment

        A                 XY             A1

        A                 XYZ          A2

        A                 XT            A3

The final result in a pivot table should be 

Company   Text1  Text2  Text3   Comment1  Comment2  Comment3 

      A                XY         XYZ       XT             A1                  A2                    A3

There is a way to do it? I don't know the exact Number of Text or Comment that I have in the Table. 

Thanks for any help

[agni_gold]

This can be done in scripting (Cross Table & Transpose )

[pascos88]

Hi thanks for your answer, 

can you suggest to me how? 

Best

[pascos88 · Accepted solution]

I solved the problem with Generic Load. 🙂