Build me an Excel database from .txt files
Budget: €30 – €250 EUR
I am looking for somebody to help me out in creating an Excel database (one sheet only). I have about 3500 .txt files with the following characteristics: (i) one file for each day between 2009 and 2021 (i) every file includes the same table (iii) the table includes as many rows as the minutes included in a day (iv) columns are, for example "wind speed", "temperature", "rain" ...
My goal is to have all these data in one Excel sheet only so i can analyze the data.
For example, I would like to have all the data in one sheet only because I would like to analyze, in the last 5-10 years, how strong was the wind in the hours between 8 am and 5 pm. I cannot do it if I am not able to run a simple vlookup formula or a pivot table. To this end, I need all the data in the same Excel sheet.
thank you. I attach an example of the .txt file. As I said, I have about 3500 of this file.
My goal is to have all these data in one Excel sheet only so i can analyze the data.
For example, I would like to have all the data in one sheet only because I would like to analyze, in the last 5-10 years, how strong was the wind in the hours between 8 am and 5 pm. I cannot do it if I am not able to run a simple vlookup formula or a pivot table. To this end, I need all the data in the same Excel sheet.
thank you. I attach an example of the .txt file. As I said, I have about 3500 of this file.