Dump an array to multiple columns

Support
#1

I've figured out how to dump 1 column to another. But I'd lake to take the input of multiple columns and dump that content. Can't figure out if DumpTo can do that???

#2

Dumping a range is pretty straight forward:

However, there seems to be a bug associated with the DumpTo function:

#3

Thanks for the illustration and explanation.

DumpTo is the function that I'm really trying to get to work. I'd like to use it in a similar manner to ImportRange in Google Sheets.

Any other ideas?

#4

Can you give me a specific situation?

#5

I'm just trying to take multiple columns and dump them into another worksheet. for example, take A2:F345 and dump that data in to a sheet named Output.

#6

Okey, and you don't want to use Dump for this purpose? For example, place the Dump formula in the sheet named Output.

#7

Using DumpTo is cleaner and it's much better for setting up templates.

#8

Okey. I have reported the DumpTo bug to Niels.

#9

Thanks a lot.

Just to be clear, this part of the description is what makes DumpTo more flexible -- "The array that is being dumped to another range is "free" from the original formula dependency. "