From a customer I receive a list of orders, where multiple departments orders are in one row.
I would like to “move” certain columns to new rows like the picture below.
I have tried to look at all the transforms, but can not seem to find one which matches my need.
Does anybody have a good idea of how to achieve this?
And here is an Excel-file with test data. It contains two sheets. One named Input and another called Desired Output.