Many thanks Iris,
your solution, however, doesn't seem to work for more than one row and looping through 1 mio rows would not be fast enough. I attach my current workflow to illustrate want I want to achieve. It seems complicated to me.
Regards Jerry