How to bring data into (at least) 3rd normal form?

Dear KNIMErs,

how would you approach data(base) normalization in KNIME?

The reason I am asking is that I am diving head first into PowerBI and that one is really (as in ‘really really’) slow when it comes to ETL tasks. Nice that MS has given us PowerQuery, but it is a snail compared to KNIME (I guess, I should learn DAX but I just don’t want to :wink: )

So I have learned that normalized tables work very well in PowerBI especially if you want to have overview and drill through pages from your data.

The thing is, I have no clue, how I could normalize the data in KNIME?

So what I basically want to achieve is to go from something like this:

to something like this:

… and this …

My assumption is, that it’s not only more visual but also faster than PowerBI.

Any idea, how to “de-join” (so to say) this?

Thank you!