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 |
Solved! Go to Solution.
@Nicole_Marx this should help, let me know how you get on
great! a simple solution! thank you