CombineTwoArrays Function

Hello everyone,

I appreciate all the replies but no success (see attached).
It looks like you have already given me a solution and - I am sure it's something simple - but I just can't get it to work.
Any Aha suggestions?

//Ola


---
I have this formula =ScatterChart(G34:H38;;;;;;;;;;;;;;;1841892) in another (big file)*.
Here I would like to replace G34:H38 with the new Function.
My x-y values comes from various rows in a large spreadsheet, but 'Sparklines for Excel' want (unfortunatelly) a continous region.

I have also tried
http://www.cpearson.com/excel/VBAArrays.htm (could not get it to work)
http://www.dailydoseofexcel.com/arch...bining-arrays/ (not working)