Superimpose two tables

Question

Hello,

I have two tables where the non-empty elements of one are not located in the same place as the non-empty element of the other, and i want to superimpose the two tables so that I obtain a table with all the elements,

For example, i have these two tables :

12    3

214

And i want to get :

12214 3

How can i do this in Alteryx ?

Best regards,

Qiu · Answer

@Ous1995 
Since it is superimpose, then we just have the row# and column#

1207-Ous1995.yxmd

CoG · Answer

This can be done with Transpose, Union, and Cross-Tab like so:

Sample Workflow.yxmd