Dump

  =Dump({object vector}, [transpose=FALSE]) : object

Purpose

Macro function that takes an array output of another function and Dumps it on the spreadsheet.

Using this function together with an array function such as XPathOnUrl is pretty powerful (and will make it work like Google Docs’s ImportXML).

Note: Dump() adds a comment in the formula cell to be able to remember what cells to clean-up when input changes in size.

Converting to values

We recommend using the Converter tool to convert dump formulas to values. The Converter also removes the comments automatically.

See

Guides

• Working with arrays in Excel
• Convert formulas to values

Related Functions

• DumpTo