Forum Discussion
Power query help needed
I have a sharepoint folder with csv files. There will be a file uploaded to this folder each day. Filename will have the date prefixed for each file. The problem is each file have first 10 rows as...
to know how to do this watch my video
Table.TransformColumns( #"Removed Columns",{"Data" , (x) => Table.Skip( Table.PromoteHeaders(x),10)})