Hello,
I have a excel with al lot of sheets per region (500 different names). All have the same form.
On each sheet in different rows, I have measurements for each day. (Timestamp : 365 d)
The name is in the sheet (yellow) and also in the sheetname (tab).
Now I want a table where for each day, I have a new colomn per region. 
Example for 3 regions is attached, also how the result should look like.
Thanks for any tip!
+46Does it need to be dynamic, or can you manually import the list of names to expose?
If you need to do it dynamically it's a bit more complex
merge_sheets.fmwt
merge_sheets_dynamic.fmwt
Does it need to be dynamic, or can you manually import the list of names to expose?
If you need to do it dynamically it's a bit more complex
merge_sheets.fmwt
merge_sheets_dynamic.fmwt
I should be able to make a list of all the sheetnames. So not dynamic I think.
+46I should be able to make a list of all the sheetnames. So not dynamic I think.
I've amended the answer to include an example
Does it need to be dynamic, or can you manually import the list of names to expose?
If you need to do it dynamically it's a bit more complex
merge_sheets.fmwt
merge_sheets_dynamic.fmwt
Thanks is exactly what I needed !! SUPER! Having fun with FME !
