Question 1: Use multi-row formula to fill down just one row. Question 2: I have a table looks something like this in my workflow: Record ID123451B2321321321321 2234723432412342342134324234324112343243 4B1234324324234 5 6B13324234234324 712314324234123432432134234231324324232343242348 9B12432421342342 I'm trying to get the adjacent rows with values. For example, records 1 and 2 are adjacent and both have values; similarly, records 6 and 7 are adjacent and have values in both. I want to extract all the rows like these.

Filtering out adjacent rows with values

Question 1:

Use multi-row formula to fill down just one row.

Question 2:

I have a table looks something like this in my workflow:

Record ID	1	2	3	4	5
1	B2321321321321
2	2347234324	1234234	2134324	2343241	1234324
3
4	B1234324324234
5
6	B13324234234324
7	12314324234	123432432	13423423	132432423	234324234
8
9	B12432421342342

I'm trying to get the adjacent rows with values. For example, records 1 and 2 are adjacent and both have values; similarly, records 6 and 7 are adjacent and have values in both. I want to extract all the rows like these.

Workflow

Accepted answers

AngelosPachis

Hi @45179902 ,

Maybe this workflow answers your question? Not sure what you wanted to achieve in Q1, which row you wanted to fill down. Is it Record 4?

sample_workflow.yxmd

lizhaozhi

I have actually solved the problem myself! First reverse order the rows, then fill down column 2 to fill the B######## rows, then use Filter to filter out the rows with non-empty column 2.

All comments

AngelosPachis

Hi @45179902 ,

Maybe this workflow answers your question? Not sure what you wanted to achieve in Q1, which row you wanted to fill down. Is it Record 4?

sample_workflow.yxmd

Christina_H

When you talk about adjacent values are you just looking at column 1? So you would want to include the rows even if the rest of the columns were blank? If so, this will do it:

Adjacent rows.yxmd

lizhaozhi

I have actually solved the problem myself! First reverse order the rows, then fill down column 2 to fill the B######## rows, then use Filter to filter out the rows with non-empty column 2.

lizhaozhi

@Christina_H Hi Christina, I'm talking about adjacent rows, not values. In the example, rows 1 and 2 are "adjacent" because there's no empty row between them, and both of them have values in side. They're not empty rows either.

Christina_H

@45179902 From your description I had come up with 3 different ways to answer your question depending on what exactly you meant. The version I went for filtered out adjacent rows with values in column 1 regardless of the other columns. The others were looking for adjacent values in column 1 and a value for at least one of them in column 2 and returning the rows as they appear in the input, and looking for the same rows but copying the values into the blank row of each pair.

If you've found your own solution though, that will definitely do what you want it to!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703