Combining SharePoint CSV File - Not Properly Merging

[Anonymous]

The goal is to have weekly sent CSV file loaded into SharePoint and with automated refresh data model. As I receive the raw CSV files, they come already comma delimited. There are instances where the cleansing is needed so that is done within the file and Text to Column delimited by comma to complete for each file. Each file has all of the same column headers, all file types are same, and all Text to Columns delimited by comma have been done within CSV file prior to loading PBIX. Each file tab + name is different because it is saved into SharePoint by date (ex: 20241018.SharePoint_Data / 20241023.SharePoint_Data). Below is a function should help me merge the files together but is resulting in the current output. 

= Table.TransformColumns(#"Filtered Rows",{"Content", each Table.PromoteHeaders(Csv.Document(_))})

Current Output = Please see screenshot. Notice Lines #39 / 40 / 41 vs #42 / 43 / 44

Expected Output = Both files should merge together and look like lines #42 / 43 / 44

Your advice is greatly appreciated. 

The goal is to have all rows like #42 / 43 / 44

[lbendlin]

You need to "Ignore quoted line breaks"  when you ingest the CSVs

[Anonymous · Accepted solution]

@lbendlin thank you for your advice and support. After alot of trial and error, I changed the SharePoint function from "SharePoint.Files()" >> to "SharePoint.Contents()". Once that was completed, combining the Binary contents together resulted in the expected output.