Workflow · Clean · Opening soon

Unmerge and fill down cells

Your Excel file has group headings with blank cells underneath. Fill them down so each row gets the right category.

Book a demo

Someone typed

“fill down the blank cells under each group heading so every row has its category”

The agent read it as

Fill down the blank cells under each group heading in Sales by region so every row has its category.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Sales by region

CSV export · 16 rows

Step

Fill down region

Step 1

Result

Region Fill Down

16 rows

Schedule

Runs when you say

Proposed

File
Sales by region
CSV export · 16 rows
Step
Fill down region
Step 1
Result
Region Fill Down
16 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 16 rows came out.

Download Sales by region sample (16 rows)Excel: File > Save As > CSV (active worksheet)

What you get back

The result of that run, the rows to look at first.

Region Fill DownSample data16 rows

Region	Product	Units	Notes
North	Aurora Desk Lamp	18	Q3 promo
North	Harbor Chair	12	·
North	Summit Monitor Arm	7	·
South	Cedar Notebook	25	Back-to-school
South	Pine Keyboard	14	·
South	Willow Mouse Pad	30	·
East	River Water Bottle	22	Campus sale
East	Stone Travel Mug	16	·
East	Bramble Tote	9	·
West	Dune Desk Mat	11	Holiday prep
West	Vista Headset	5	·
West	Lark Cable Kit	28	·

16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you fill down in Excel?

Upload your Excel export with the grouped rows. Mammoth fills down the blank cells under each heading so each row keeps the category it belongs to. You get a sheet with the categories repeated on every row.

How it works

How to use the Region Fill Down workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Region Fill Down: questions

What export should I use?

Use the Excel file that contains the grouped rows and blank cells under each heading. If your source tool can export to Excel, that is the file to use.

What happens to rows that do not match the pattern?

Rows that do not fit the fill down pattern are left as they are, or they can be handled separately depending on the rule you set. The workflow only changes the rows that match the step.

How do I change the rule in words?

Describe the group heading column and what should be filled down. For example, say to fill down the blank cells under each region heading so every row has its region.