CSV file columns are mixed up

[JackBotros]

Hi everyone,

I am exporting a CSV file from a database, but in excel some data appear in the wrong column. For example the date appear in the name column ... etc
Note that the file has more than 10,000 rows

Could anyone help me ?

 

[JEC]

What if you import the data with Power Query?

 

[JackBotros]

What if you import the data with Power Query?

Thank you for your reply

I did not try that. What is the difference ?

 

[JEC]

Importing data with Power Query is the best way nowadays. You can also transform your data (like switching/moving columns) immediately

Data --> get data --> from csv