Load txt as table in powerquery

[aurkmez]

Hello everyone,

How would you load this txt as a table? I could transform only the Customer ID column but I need to divide the rest as well.

[m_dekorte]

Hi @aurkmez,

When you select the Source step, go to the View tab on the Ribbon and enable "Monospaced"

Do your column values align?

If not, please share a sample file

[aurkmez · Accepted solution]

I was able to solve this with some effort, if someone is curious I can send my .pbix file. Thanks!