🌊 Dynamic Arrays

The modern Excel revolution. One formula, many results. Spill ranges, generate sequences, and reshape data instantly.

Generate a list of numbers (1, 2, 3...) in rows or columns. Perfect for creating ID lists or calendars.

🎲 Simulation

Create a grid of random numbers instantly. Great for testing data or simulations.

Flip data orientation. Convert a vertical column into a horizontal row (or vice versa).

04. VSTACK / HSTACK

Stack arrays vertically or horizontally. Combine data from multiple ranges into one master list.

05. TOCOL / TOROW

Flatten a 2D grid into a single list. Useful for transforming matrix data into a clean column.

✂️ Extraction

06. TAKE / DROP

Keep or remove specific rows/columns. "Take the top 5 rows" or "Drop the first column".

Extract specific columns from an array by index. Reorder or filter columns dynamically.

⬅ Back to Excel Menu