Forum Discussion

JPNK's avatar
JPNK
Frequent Visitor
3 years ago
Solved

Merge columns as new events

Hello all, I've been trying to find a solution to my problem, and I haven't been able to work it out. Probably I'm not using the correct keywords, as when I search for "merge columns" it usually dir...
Need Help
  • JPNK's avatar
    JPNK
    3 years ago

    Actually I already figured it out.

    So the solution for me was to merge all colors into a new column

    all_colors = Product_colors[Color1]&","&Product_colors[Color2]&","&Product_colors[Color3]

    then I clicked on split column by delimiter

     

    On spliting, I chose to split into rows instead of columns

     

    After that I just filtered out all the blanks from this new column, and job done.

     

    Thanks to anyone who read this request

JPNK's avatar
JPNK
Frequent Visitor
3 years ago

Actually I already figured it out.

So the solution for me was to merge all colors into a new column

all_colors = Product_colors[Color1]&","&Product_colors[Color2]&","&Product_colors[Color3]

then I clicked on split column by delimiter

 

On spliting, I chose to split into rows instead of columns

 

After that I just filtered out all the blanks from this new column, and job done.

 

Thanks to anyone who read this request