Power query - Imported data from a folder with different files - rows misaligned

[Marta_Oliveira]

Hello,

i',m having a difficulty with imported data from a folder wich has files (1 file per month).

There's one line in each file that is misaligned and have six cells with additional information that I don't need

I need your help to solve this difficulty to allow me to treat the data.

thank you in advance.

kind regards,

marta

[ChielFaber]

Could you provide some dummy data to get a clear view of the problem your facing?