How to copy one column into another sheet?

[MandyL]

Hi,

There are two different columns, one is on the sheet1 called "Product Line", and the other is on the sheet2 called "User". May I know to output these two columns in one sheet? like excel copy and paste function, just copy one column to another sheet. Thanks!

         

Output

Best regards,

Mandy

[grossal · Accepted solution]

Hi @MandyL,

you can do this using the Join and Union Tool.

You join the records by position resulting in a dataset with the first 3 rows and than union all "not matched" columns from the R Anker.

Sample workflow attached. Let me know if this helps.

Regards

Alex

PS: If sheet 1 has more records than sheet 2 or you don't know which one will have more records, you should also connect the L anker to the Union Tool, but be careful, always connect the J Anker first to the Union tool.

[VianneyM · Accepted solution]

Hi @MandyL,

You can use the Join Multiple to get both data sources together - configure it as: Join by record position

Let me know if you have questions

Best,

Vianney 

[MandyL]

Thank you @grossal . It works. Thanks!

[MandyL]

Thank you @VianneyM. It's works. Thanks!