Skip first row of CSV file before processing

Hi GW999 

Try this on the AddFileContentsAsColumn step

AddFileContentsAsColumn = Table.AddColumn(#"folder1", "Custom", each Table.PromoteHeaders(Table.Skip(Csv.Document([Content],[Delimiter=",", Encoding=1252]),1)))

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

GW999 

Try specifying the number of columns in the second argument of Csv.Document(). Instead of the current

           [Delimiter=",", Encoding=1252]

try

      [Delimiter=",", Columns = 2, Encoding=1252]

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers