New Column in my Source FIle

A new column has been added to my source file.  The column is located in the middle (not the end) of the file.  This column has valuable information that I need to pull into power query so that i can...