Separate and Assign Columns to Other Columns

Question

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.

ColorGreenColorBlueColorPurpleGreenLight GreenGreenDark GreenBlue PurpleDark PurplePurpleLavenderPurpleViolet

Desired Outcome:

ColorGreenLight GreenColorGreenDark GreenColorBlue ColorPurpleDark PurpleColorPurpleLavender

ColorPurpleViolet

KGT · Accepted Answer

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 Answer

hi!

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

Your T output should have:

column1column2ColorGreenColorBlueColorPurple

Your F output should have:

column1column2GreenLight GreenGreenDark GreenBlue PurpleDark PurplePurpleLavenderPurpleViolet

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:

column1column2Right_column2ColorBlue ColorGreenLight GreenColorGreenDark GreenColorPurpleDark PurpleColorPurpleLavenderColorPurpleViolet