View Full Version : Extracting first two rows from each of several folder files

2016-10-06, 03:04 PM
Hi there, I think I am missing something on a solution for this problem. I have studied blogs and forum and am just not quite getting it
So help would be greatly appreciated.

I have several xls files in a folder that I want to process. I need the values of the first two rows of each file rom column1 to be in their own column and as an identifier for that file. In other words, I want the information from each column to be copied down each file. Row1 is location, row2 is filetype. I want to find the row 1 of each file and enter into a column. then do the same for row 2.
I am able to make a query by loading one of the files and transforming the first two rows into two columns.
I don't know how to apply that query to the balance of the files in the folder.

Suggestions please...

2016-10-06, 03:41 PM
This can help you: http://datapigtechnologies.com/blog/index.php/using-power-query-to-combine-data-from-multiple-excel-files-into-one-table/

Or post your M and we can amend it.