How can I merge identical sheets in excel to 1 table with diffent colomns?

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!

Page 1 / 1

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

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.

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 !

Sign up