Concatenate and recorded into a new Worksheet/Workbook

[zealisk]

I have the following data

ID	Add	Add	Add	Add	Remove	Remove	Remove	Remove	Remove
x123	Banana	Apple	Orange	Carrots	Grapes
x234	Banana	Apple	Grapes		Coconut
x131		Apple	Orange	Carrots	Grapes

etc.

I want to concatenate ID and all the Add columns and have it recorded in another worksheet/book

And same thing for the Remove column

So the final output looks something like:

Add	Remove
x123-Banana	x123-Grapes
x123-Apple	x234-Coconut
x123-Orange	x131-Grapes
x123-Carrots
x234-Banana
x234-Apple
x234-Grapes

etc.

The Add and Remove columns could be more than 4. Basically I want to concatenate all the Add column and record them on a different worksheet (Column A). And all the Remove column recorded in same worksheet (Column B).

[FloraF]

Hello, 

what you are trying to do is definitely do-able in Alteryx. Please see the attached workflow for your convenience. 

**If this solves the issue, please click on the like below" thank you!

[Qiu · Accepted solution]

@zealisk 

This is an interesting one. we can use Transpose and CrossTab.