Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ITakacs
Contributor
Contributor

Cross Table / Generic Load? How to transpose specific columns and rows

Hi all,

I have the following dataset:

ABCD
BlankBlankCXDX
BlankBlankCX2DX2
NameBX1Data1Data3
Name2BX2Data2Data4

 

What I would like to achieve is the following:

ABCDE
NameBX1CXCX2Data1
NameBX1DXDX2Data3
Name2BX2CXCX2Data2
Name2BX2DXDX2Data4

 

How could I achieve this in the simplest way?

Thank you!
Istvan

Labels (3)
2 Replies
Channa
Specialist III
Specialist III

for name how you can map CX,CX2,DX and DX2..do they static??

Channa
ITakacs
Contributor
Contributor
Author

Yes, let`s say they are.