Changing the format of the table with addition of dates

[Menoufi]

Hi All - would appreciate some help for the following:

I currently have the data like this:

And I would like to transform it into this:

Thing is, also I would like the process to automatically add new dates down the column when I upload a new CSV with new dates in the future. Is that possible with Knime? If so how? I would appreciate all the help possible because I have been trying to do it for 3 days now using grouping and pivoting but I am just stuck.

Thanks in advance!

[HansS]

Hi @Menoufi welcome to KNIME Forum

An Unpivot node within a Chunck Loop will do the trick. changing_format.knwf (32.5 KB)

gr, Hans

[Menoufi]

HansS it eorked perfectly thank you but I have just one little thing left:

If I have more than one catogery and not just revenue, how do I make the categories as columns as shown below: (I added GP next to revenue)

**

[HansS]

Hi @Menoufi

Tnx for your feedback. To add another Categorie, add another branch to your workflow.
changing_format_v2.knwf (55.1 KB)

gr. Hans

[Menoufi]

Hans THANKS A MILLION!