meant inelegant :-) The function that I'm trying to copy is based off pulling proprietary data from our internal system so can't upload it to the internet unfortunately, which would be the best way to express what I mean.

Goal is fundamentally is a function, in which you reference the data you want in the function, the function then populates a cell range of the correct size with the array of data automatically. Which is what the other function manages to do. The big benefit of this is its far easier as all the user needs to do is put the function in a single cell.