Auto-fill rows until next non-empty cell

1

I have a table where the first column has blank cells, but the other columns have information. I want to fill the blanks in the first column using the data above them.

Example:

BEFORE

Column 1 Column 2 Column 3
Apples Red $2
Green $1.50
Yellow $3
Grapes Purple $8
Green $4
Peppers Red $1
Orange $2
Yellow $3
Green $3.50

AFTER

Column 1 Column 2 Column 3
Apples Red $2
Apples Green $1.50
Apples Yellow $3
Grapes Purple $8
Grapes Green $4
Peppers Red $1
Peppers Orange $2
Peppers Yellow $3
Peppers Green $3.50

I found solutions for both Excel and Sheets, but I’m unsure how to best replicate that here.

2

When you click in a cell, you will get a blue dot in the bottom right side. If you hover over that, you will see an explanation, if you select it, you can drag it down to fill.

If you select a single cell, it will just copy that value as far as you dragged. If you selected multiple cells, it will determine a pattern, and then follow that pattern.

3

Apologies, I should have been more clear.

I am aware of the pull down autofill function. The issue I have with that solution is that it is AI which I personally avoid as much as possible. Also even if I did want to use AI, my table has 3000+ rows and it would likely eat up any credits I have.

In both the excel and sheets solutions they used formulas, whether in a new column to copy paste or within the original column. That is what I am hoping to find, a formula solution.

4

I came to need this after wanting to replicate this feature from Excel’s Power Query (not sure if you did too?).
@Sarah_Noah_K-POP_BAZAAR

This article by @Christiaan_Huizer has exactly what you need.
https://huizer.medium.com/missing-values-in-a-coda-list-4334a73a2ae3

In it, he links to the original solution posted on the forums here.

Nick

2 Likes
5

Thank you so much! I appreciate it!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.