Avoiding cross join and getting expected output

[nirvapatel1998]

Hi All. I am trying to join group from sheet 1 and sheet 2 and get the desired output from the output sheet attached in excel. I tried using tile tool and multi row formula tool to get the unique value and avoid cross join but it not giving me correct result for Group R when join is done based on group and unique value. Any suggestions on how I can solve this. Thank you in advance. 

My sheet 1 and 2 are inputs 

Output sheet = Desired output from Alteryx Workflow. 

[Luke_C]

Hi @nirvapatel1998 

I don't think there's a way to systematically do this, there's no logical link for the group R values. The other groups appear to be in the same order, so you could use a tile tool to assign a sequence number within each group and join on group + sequence. That would alleviate the cross-join issue, but is essentially joining on the record position in each group so group R will still be an issue.

[nirvapatel1998]

Thank you so much for your help!! 

[binu_acs]

@nirvapatel1998 One way of doing this