Add Column and Fill Rows with the As of Date/Time on the Exported File

[purekarting]

I am using Power Query to combine CSV files from a folder. Each file has 2 "junk" rows which are removed at the Transform Sample FIle before the files are all combined. However I would like to grab the "As of" date/time from those rows and fill a new column with that info prior to removing those top 2 rows. Can this be done with PQ on the Transform Sample File so that each row on the imported CSVs can show when that row data was exported?

 

[Matt Allington]

see my article here Convert a Cell Value into a Column with Power Query