Split columns data into Row wise

[qvqs14]

Hi Team,

I am new to Qliksense, I am having the below requirement.

I am having the below sample data and i need to convert my columns data into Row wise.

Mentioned the desired out put as followed by sample data.

Sample Data:

Account Number	UserID
101	UserID1
101	UserID2
201	UserdID1
301	Null
301	UserdID2
301	UserdID3

Desired Output:

Account Number	UserCount1	UserCount2	User Count3
101	UserID1	Null	Null
101	Null	UserID2	Null
201	UserID1	Null	Null
301	Null	Null	Null
301	Null	UserID2	Null
301	Null	Null	UserID3

Please help me with the situation by using Qliksense Script. Thanks in Advance.

Regards,

QVQS14

[SerhanKaraer]

Hello QVQS14,

There is no direct pivotting option in qlik scripts, but a combination of generic load and joining does the job.

Rob has a good explanation for your use case in his blog:

https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/