Duplicate Rows with Different Content

[Faisal___28]

Hello everyone,

Im trying to achieve the below. I had seen this before but Im not able to recollect how it was done. 

Data

Column A	Column B
A	1
B	2
C	3

Result To achieve

Column A	Column B
A	1
A	2
A	3
B	1
B	2
B	3
C	1
C	2
C	3

Your help would be highly appreciated.

[atcodedog05]

Hi @Faisal___28 

Here is how you can do it.

Workflow:

Hope this helps : )

[AkimasaKajitani]

Hi @Faisal___28 

This workflow will work well.

[Faisal___28]

Hi @atcodedog05 ,

Thanks for the solution but im facing another issue as I dont have equal no. of records in both the columns. Column A contains 7000 records and column B 64. Hence im not able to replicate for all the records. Pls help

[atcodedog05 · Accepted solution]

Hi @Faisal___28 

Try this and make sure the Append tool it set to allow all append (refer highlighted). Hoping Blank values are Null.

Hope this helps : )

[Faisal___28]

Hi @atcodedog05,

I believe there is a limitation in the number of outputs. I ran the workflow twice with the two sets to achieve my result. Thanks for the help. 

[atcodedog05]

Happy to help : ) @Faisal___28 

Cheers and have a nice day!