restructure data from two columns

[alec1982]

I have a table as follow and I want to change the structure so I can see how the data is connected. as you can see A is connected to B then B on the next line is connected C and then C on the next column is connected to D. I want to rebuild this lineage so it is a single row. any idea?

Column1         Column2

A                         B

B                         C

C                        D

x                         y

y                        z

Output will be as follow

Column1  Column2  Column3   Column4

A                    B                 C                   D

X                    Y                   Z

[kaushiknsolanki]

Hi what you need is the hierarchy builder. In Qlik you can achieve this using the Hierarchy function.

Here is the link for more information.

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...

[alec1982]

thank you for the help. having hard time to get the table to the structure I listed above. would appreciate if you can try it.