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...
Hi Anonymous
In your query add a step : Home tab, click on Remove Rows -> Remove Top Rows then enter 10
Phil
this will only remove first 10 rows from the first file. I want this to work for all the files in the folder.