Extracting first two rows from each of several folder files

Freedup1

New member
Joined
Jul 4, 2016
Messages
2
Reaction score
0
Points
0
Excel Version(s)
office365 E2
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...
 
Back
Top