u/THE-STAR_812345

I imported some data into Google Sheets and a bunch of rows are blank in one column because the value only appears once for each group.

Right now I’m basically fixing it manually and it’s taking forever.

Example:

Category

Shoes

(blank)

(blank)

Hoodies

(blank)

I just want the blank cells to automatically use the last value above them.

Feels like there should be a really easy way to do this but I can’t find one.