Separate and Assign Columns to Other Columns

[Eduardomejia189]

Hello I was wondering if it was possible to separate and assign columns to other columns (Hopefully makes sense) Im trying to do something like this for other data but heres the vision. The blank is intentional! But if I could get a visual that would be great since im fairly new to alteryx thank you!!!!

Data Ex. 

Color	Green
Color	Blue
Color	Purple
Green	Light Green
Green	Dark Green
Blue
Purple	Dark Purple
Purple	Lavender
Purple	Violet

Desired Outcome: 

Color	Green	Light Green
Color	Green	Dark Green
Color	Blue
Color	Purple	Dark Purple
Color	Purple	Lavender
Color	Purple	Violet

[KGT · Accepted solution]

Looking closer, you already have the groupings... Filter on [Column1]="Color" and then Join the 2 outputs and a union for the results (may require creating some fields)

The way I would go about this is to tag rows based on the header that you want and then use a crosstab.

So, using a formula tool, create a field with 

IF [Column] IN ("Green","Blue","Red","Purple") 

THEN "Primary"

ELSEIF Contains("

[shancmiralles · Accepted solution]

hi! 

I used a filter tool for your data. then i filtered your first column for the word "color" . 

Your T output should have:

column1	column2
Color	Green
Color	Blue
Color	Purple

Your F output should have:

column1	column2
Green	Light Green
Green	Dark Green
Blue
Purple	Dark Purple
Purple	Lavender
Purple	Violet

after this i connected a Join tool.  So:

Filter tool              |  Join tool

True Output ----> Left Input Anchor

False Output  -->Right  Input Anchor

then for the Join Tool Configuration i join them by Left: Column 2 <- -> Right: Column1

Keep all column for left and just uncheck Right - Column1 

output is:

column1	column2	Right_column2
Color	Blue
Color	Green	Light Green
Color	Green	Dark Green
Color	Purple	Dark Purple
Color	Purple	Lavender
Color	Purple	Violet