How to copy one column into another sheet?

Question

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

AlteryxComm.xlsx

grossal · Accepted Answer

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.

vmartinez · Accepted Answer

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