Joining Row and COlumn intersection into a table with rows

[Nicole_Marx]

Hi Alteryx users, 

I am looking for a method to take the intersection of my rows and columns and create a new table from it but just showing the (intersected) data in the rows instead. 

Current state
	AB10	CD10	EF10
CD10	10
EF10		100
IE10			10000
Desired State
CD10-AB10	10
EF10-CD10	100
IE10-EF10	1000

[aatalai · Accepted solution]

@Nicole_Marx this should help, let me know how you get on

[Nicole_Marx]

great! a simple solution! thank you