I have a total of 216 small CSV files that I need to combine in a specific way.
The consolidate function in the Data tab doesn't seem to do what I want (and I seem to have forgotten what little I knew about PowerQuery and the Data Model).
Per the attached example (Sheet 1 in attached example), each CSV file relates to a month. I need the months combined into before/after sheets - each month having a column (ideally with the date of acquisition as the column header which is contained within the CSV filename) (see the attached example that I did by hand).
I know this is a relatively straightforward transformation when importing the data, but I don't know how to do it.
A bit of help would be much appreciated!
``````
In case it is of any relevance:
The data are mean temperatures which are calculated using a masked/unmasked process in buffers at 100m intervals extending from 100-2000m from solar power installations and are generated from Landsat images using Google Earth Engine before being saved as individual CSV files for each processed image (see Sheet 1 for exemplar data in the attached Excel Workbook).
There are three sites, each having before-construction/after-construction data. Site one has 5 paired sets of CSV files (5 x 2 x 12), and Sites 2 & 3 2 sets each (2 x 2 x 12).
Each CSV file has 40 data.
Editing the Earth Engine code would take even longer than doing this by hand...
Bookmarks