Thanks a Lot!

It works very good, there was a little syntaxis error on it.

Thanks again.

" wrote:

Hello,

You press ALT + F11, insert a module, copy my source code into that
module and switch back to your Excel sheet.

Then you select your destination area and enter
=copy_row_wise(A1:B32)
as an array formula (enter with CTRL + SHIFT + ENTER). Make sure that
the number of source and destination cells match.

HTH,
Bernd