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...
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...