Merge two columns of different size

[StuttgartPower]

I have two input columns, which I need to bring together as follows:

Input Column 1	Input Column 2	Output Column 1	Output Column 2
A	A1	A	A1
B	A2	A	A2
C	A3	A	A3
	B1	B	B1
	B2	B	B2
	B3	B	B3
	C1	C	C1
	C2	C	C2
	C3	C	C3

Can you help me to get this output?

[atcodedog05]

_

[atcodedog05]

Hi @StuttgartPower 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Per]

Hi @StuttgartPower,

Thanks for providing another example, however I am not sure which logic to apply that would make anyone recognize that Tier987 should be joined with A1 and not B1?

There needs to be some similarities between the fields you wish to join in the two columns. It could be that the first letter in Column 2 related to first entry in Column 1 (so A maps to Tier987, B to Wave285 and D would map to Pole578 (as an example))

[atcodedog05]

@Per great point. I just assumed its the sequence.

[morr-co]

I think this may get you what you need. It is predicated on joining by record position which isn't a great practice in my opinion. I would recommend reviewing the results of your entire data set before implementing this.

[Per]

@atcodedog05 I did as well, but after reading that your suggestion did not do the trick, I think it might be something else 🙂