Forum Discussion
split columns with with multiple spaces between fields
Hey Team, We need to split text which looks like this to columns: Name= John Doe Date=2021-2-3 Address= New York Name= Sam Doe Date=2021-2-3 Address= City= Paris Is there a way to parse ...
I would split by delimiter "=", then Text.Trim the whole table to remove any leading or trailing spaces. I would then add an index column and move it all the way left. Then you should be able to use the Pivot function in the GUI to pivot the columns.
--Nate
Can you help me with a sample pbix file?
I'm on my phone on the road. Give me an hour or so 🙂
--Nate
Thank you!