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.
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.
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.
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
Thank you so much! I appreciate it!