Power Query Importing Data from CSV file

[Trickyaz1991]

Hi all,
first time here,
nice to meet you all.

I am currently getting my skills up in excel and ripping my hair out doing it.

so the question is I am currently creating a power query for my worksheet when I import data from file(csv file) which I want it to do the following things;
- delete rows with blank and data I don't want ------ I have done this.
- reorganize columns ------- I have done this
- deleted unwanted columns ---- I have done this

the last thing I am trying to do is there is one column on the csv which is column 6 but on the worksheet, I want it be in column 8 so i want some type of column space which wont effect those cells i have formulas for
on column 6 and 7 in worksheet.

hope this makes sense and someone can help me because scratching my hair out doing it.

regards,

Aaron.

 

[Trickyaz1991]

Yes, I have followed all dot points you have stated.