Forum Discussion
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...
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
NewStep=Table.RemoveColumns(Table.UnpivotOtherColumns(Product_colors,List.Select(Table.ColumnNames(Product_colors),each not Text.Contains(_,"Color"))),"ColorX","Color"),{"ColorX"})