Forum Discussion
Spliting (inconsistent data) column into multiple columns - Power BI
Hi, I have a table with a column of data having multiple pieces of information in an irregular pattern. please help me to split data into multiple columns as many as possible - campaign name, co...
srikanthjukuri
Is it possible to change the data structure of the source table? I am thinking the easiest way is if you can just replace the first row to the same format like the rest. Then you can simply split with "-" in Power Query.
17Q3-Campaign AUK-SOC-SB-ACQ-Social (Campaign AUK-SOC-17Q3-ACQ-SB-Social)
Campaign A-FI-16Q1-ATL-SB
Campaign A-FI-19Q4-ATL-GOC-WelcomeOffer-Dec
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.