Normalize data

[Syndicate_Admin]

Good to all,

I am trying to normalize a downloaded database in .txt.

The truth is a bit complicated for me because when choosing the different types of separators I eliminate columns when using the option of tabper seaparador.

Help please.

[amitchandak · Accepted solution]

@Syndicate_Admin ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You need to try Split by Delimiter in power query