Forum Discussion
sevenhills
Super User
Super UserConverting file data into columns - power query
Hi all,
I am combining multiple files, which are semistructured. I am providing sample data which I need to convert into columns. Any help is appreciated. The data looks like below:
...
lbendlinSuper User
Super UserI would suggest you ... run for the seven hills ... (Sorry, could not resist)
Since the data is in fixed width you can split each line (row) by position as needed. It will be a giant effort to set that up but it's not that complex.