Forum Discussion
Filtering out data from one column into another
I got a column in my table called attributes_overview in which information is just unsorted. It looks something like this: Title | Attributes_Overview | Price Laptop A | ADE34DG 123.123.123.123 ...
Hi Anonymous
In Power Query, you should be able to Split the column by delimeter
From PBI Desktop > Transform Data > Split Column > By Delimeter
From there :
I placed the "|" in the post to mark the different columns. I need to split up this part "ADE34DG 123.123.123.123 Active" but the order of the column is random and the MAC-Address is also always different.